Basically you open up the ODBC Administrator (ie. Control Panel - Administrative Programs) and then create a new ODBC (System) DSN (ie. a "link" to backend database using the correct driver stated.) You're basically establishing a gateway whereby the server data can communicate with MSAccess. Supply any passwords needed to gain access to the database while creating the ODBC DSN and supply the driver to use (which is most likely a 3rd party driver if it's Firebird - you'll need to get the ODBC driver from them and then install so it shows on the ODBC listing of available drivers. (Note: The ODBC DSN also has to be created on each machine, citrix session, terminal server, etc... that is going to be using the mdb file. The ODBC DSN Name MUST be named EXACTLY the same from machine to machine. Otherwise you'll have problems.
Once you've done that, in MSAccess, you can "link" a table from that database using that same ODBC DSN by selecting File -> Get external Data, and then select ODBC Driver, and then the ODBC DSN name you gave the ODBC DSN in the first step.
You should then see a listing of the tables and highlight the ones you want linked into MSAccess (Note: click the Save Password box to make it easier the next time you open the mdb file and thus don't have to supply a password.)
Last edited by pkstormy; 09-20-09 at 01:36.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)