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 one of the tables located in the back end, with the connection being a link in the front end.

 '-- Section 3: Open the table containing the list of linked tables Set dynSharedTables = dbLocal.OpenRecordset("tblSharedTables", _ dbOpenDynaset) On Error Resume Next dynSharedTables.MoveLast Set dynTestTable = dbLocal.OpenRecordset(dynSharedTables!TableName, _ dbOpenDynaset) intCurrError = Err.Number strCurrError = Err.Description Do Until intCurrError = 0 On Error GoTo Error_ap_App_Init Select Case intCurrError Case apErrFileNotFound, apErrTableNotFound, _ apErrPathNotValid, ...

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