ODBC DSN Driver to use?

I hope I make sense here, so bear with me. I am just learning ODB and database creation in general; I hope someone can push me in the right direction with this question.

I have 2 databases and I need to get them linked. One is in ODB and one is in Access 2003. I want to link the ODB database into Access 2003.

I understand that you would have to use ODBC and add a Data Source name (is that right?). I also think I need to select a driver so Access can figure out what's going on.

So here I am looking at the MS ODBC Administrator Dialog box:

Which ODBC driver do I need to select for ODB?

Do I use user DSN? System DSN? File DSN?

Very confused and thank you in advance for setting me straight,

Toph2112

hi Toph2112 -- You can

Thu, 05/15/2008 - 2:16pm

hi Toph2112 --
You can create a link to the ODB tables from another DB or you can open the ODB database directly in access 2003.

If you want a DSN for your ODB, Right click on the Mass Action button from within ODB and choose the option "Create ODBC DSN...". It's easier than you thought!

-rich cowan
ODB Support Team

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.