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" ... |
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.