Search results

I needed to create a linked table with VBA. To do this I used the following code. Set aTDef = myRPG.CreateTableDef(<NewLinkedTableName>) aTDef.Connect = <Appropriate SQL Server connect string> aTDef.SourceTableName = <New SQL Server View Name> myRPG.TableDefs.Append aTDef This works fine. But...

Consider four databases: Controller.accdb, RPG.accdb, OldSource.accdb, and NewSource.accdb. RPG.accdb has a link to Table_MyData in OldSource.accdb. This link needs to be redirected to Table_MyData in NewSource.accdb. I need to write VBA code in Controller.accdb to accomplish this without...

My dept has an aging Access repository with dozens of tables. We have hundreds of Access files (report generators) that have links to the repository tables (over 4000 links in all). We are replacing the Access repository with a SQL Server repository. The Access Report Generators, however, will...