O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required