Code to link to Interbase gdb database ?

[Adam]

Hi all,

I need to link to an Interbase Database (gdb file). Does anyone know of any
code that I can use to do this ?

cheers,

Adam

 

[Larry Linson]

My experience with linking server tables is that you have to create the
TableDef, including the link information. You can get a pattern for the
..Connect propery by linking one by hand, and looking manually at the
"Description".

When we changed databases (we had one for development and another for
production, so that was a common task), we deleted the TableDefs for Linked
tables, and created new ones with the link to the appropriate
database/table.

Not surprisingly, the DAO Help to look for is CreateTableDef (it'll be in
"Visual Basic Help" in a Module Window in Access 2000 or 2003). And, the
Help in Access 2002 on this subject is better than on some other subjects.

Larry Linson
Microsoft Access MVP

 

[Larry Linson]

My experience with linking server tables is that you have to create the
TableDef, including the link information. You can get a pattern for the
..Connect propery by linking one by hand, and looking manually at the
"Description".

When we changed databases (we had one for development and another for
production, so that was a common task), we deleted the TableDefs for Linked
tables, and created new ones with the link to the appropriate
database/table.

Not surprisingly, the DAO Help to look for is CreateTableDef (it'll be in
"Visual Basic Help" in a Module Window in Access 2000 or 2003). And, the
Help in Access 2002 on this subject is better than on some other subjects.

Larry Linson
Microsoft Access MVP