G
gdonald20
In code on then “on open†event of a welcome form I want to test the presence
(or otherwise) of a table in a SQL Server database to which the database is
linked via an ODBC connection. (i.e. I want to know if someone has stolen a
copy of the database and is attempting to run it on a separate machine
outwith our office where they would not have access to our SQL Server.)
If I find that the SQL table is not visible, I will exit the database.
It occurs to me that (on opening a welcome form) I can try to dlookup a
field on the table and then wait for a failure and pick it up in the error
trapping.
It also occurs to me that this is almost like wanting to get a car to stop
so I run it into a wall; effictive, but very crude.
Is there a better way to do this?
Thanks
Gillian
(or otherwise) of a table in a SQL Server database to which the database is
linked via an ODBC connection. (i.e. I want to know if someone has stolen a
copy of the database and is attempting to run it on a separate machine
outwith our office where they would not have access to our SQL Server.)
If I find that the SQL table is not visible, I will exit the database.
It occurs to me that (on opening a welcome form) I can try to dlookup a
field on the table and then wait for a failure and pick it up in the error
trapping.
It also occurs to me that this is almost like wanting to get a car to stop
so I run it into a wall; effictive, but very crude.
Is there a better way to do this?
Thanks
Gillian