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

REPLICATING CODE TABLES USING ADO

Although Chapter 28 discusses replicating code tables, I thought it would be worthwhile to look briefly at ap_CheckReplicatedTables in this chapter (see Listing 27.6).

Listing 27.6. VideoApp(ADO).mdb: Replicating Code Tables
 Sub ap_CheckReplicatedTables() Dim catLocal As New ADOX.Catalog Dim rstCheckRep As New ADODB.Recordset Dim cmdUpdateRep As New ADODB.Command Dim strTableName As String On Error GoTo Error_ap_CheckReplicatedTables Set catLocal.ActiveConnection = CurrentProject.Connection DoCmd.Echo True, "Checking for Replicated Tables..." '-- Attach the backend replicated table '-- and open the query that shows updated replicated tables On Error Resume Next catLocal.Tables.Delete "tblBackEndReplicatedTables" ...

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