Active forum topics
There are currently 0 users and 3 guests online.
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,