O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

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

TESTING THE CONNECTIONS OF LINKED TABLES AT STARTUP

As you continue to examine the sections of the ap_AppInit() function, now look at Section 3, which opens and tests the connection for a table located in the back end, with the connection being a link in the front end (see Listing 27.3.)

Listing 27.3. VideoApp(ADO).mdb: Testing the Links
 '-- Section 3: Open the table containing the list of ' linked tables and test the link. ' Open employee table. rstSharedTables.Open "tblSharedTables", cnnLocal, adOpenStatic On Error Resume Next rstSharedTables.MoveLast Dim rstTestTable As New ADODB.Recordset Dim strTableName As String strTableName = rstSharedTables!TableName rstTestTable.Open strTableName, cnnLocal, adOpenStatic lngCurrError = Err.Number If ...

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