Link tables – to a db with non mdb file extension (2000/XP)

Topic

New Reply

We use some software that stores it’s data in an access database.

The software uses the file extension .gpj instead of .mdb.

How can I link to the tables in this database – a colleague managed to do it but can’t remember how.

Reply | Quote

Replies

Activate the Visual Basic Editor (Alt+F11).
Activate the Immediate window (Ctrl+G)
Type the following, substituting the correct path and names:

DoCmd.TransferDatabase acLink, “Microsoft Access”, “C:OtherSoftwareData.gpj”, acTable, “SourceTableName”, “LinkedTableName”

Reply | Quote

Very interesting

Thanks

Reply | Quote