Verifying Server Connection in a Project File

As you can imagine, it’s equally important to verify the connection to the SQL Server database in an Access project file (.adp). In some ways, checking the connection is much simpler than checking linked tables in an Access desktop database. If the project’s IsConnected property is True, then the project thinks it has a good connection to some database. However, you should also verify that the connected database is the one required by the project.

When the project’s IsConnected property is False, you have some more work to do. If you expect the project file to run with a local copy of SQL Server, the code must first attempt to start the server and connect to it. If the project uses an SQL Server running ...

Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.