Test Connection to Backend Database

[Aaron5714]

I have a split database with the backend residing on a shared network drive. In my startup script I want to test if the user can access the filepath to the backend database before loading the main form. In most cases if a user cannot access the backend it would be because they are not connected to the network or have not been granted access to the directory where the backend resides.

Can anyone provide an example of VBA code to check for access to the backend, or point me to a link that might help?



Thanks in advance,
Aaron

[June7]

Google: Access vba test connection

Basically, run a query against a table and use error handling. A domain aggregate function will generate the same error as trying to open a query if table can't be found.

DCount("*","tablename")