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