Results 1 to 2 of 2
  1. #1
    AmyLambes is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    2

    Suppress Linked Table Missing Errror and Replace it with custom error message

    I have created just a simple user interface that when the database is opened it goes and checks if a security table is there and what date is in the table, if it is not up to date it says CANNOT USE, UPDATE TABLES. This lets me make sure all locations have been updated during the night and it prevents people from copying the program to another computer, because it is a hidden table.
    What happens is if they copy it to another computer and try to run it, the program says "could not find file C:\.......
    What I would like to happen is to be able to suppress this error and have it say "Call support for help with the program" or what ever I like to put there. I don't want the system error to come up.
    Is this possible?


    If not is there a way if a table is moved or copied that the contents are deleted or set to a specific value. It is a table with only one record and one field.
    Thank You for any assistance

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,951
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Hide "#Errror" Field Message?
    By 10 Gauge in forum Forms
    Replies: 4
    Last Post: 09-08-2011, 10:31 AM
  2. Suppress spell check error message
    By sabre1 in forum Forms
    Replies: 1
    Last Post: 03-24-2011, 09:58 AM
  3. Custom validation error message
    By snorkyller in forum Access
    Replies: 2
    Last Post: 03-21-2011, 03:40 PM
  4. Custom error message problem
    By thekruser in forum Programming
    Replies: 10
    Last Post: 10-06-2010, 05:14 PM
  5. Linked table from outlook missing columns
    By nehamd4 in forum Access
    Replies: 0
    Last Post: 07-21-2010, 12:58 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums