use a lookup table in accdb from a2k3

[supmktg]

I am building an a2K3 application, that will require comparison of data located in another database. That data is currently being stored in a 2007 accdb. How can I link to or import a table located in an accdb from an mdb?

Thanks,
Sup

 

[the_net_2.0]

why not import the table using the import wizard? or save the accdb as an mdb first?

 

[boblarson]

You aren't going to be able to do anything with the ACCDB from the MDB file. As far as the MDB file knows, ACCDB files don't exist. So you would have to push something to the MDB file FROM the ACCDB file but you can't do it the other way around.

 

[supmktg]

What about an odbc connection from the mdb to the accdb, like connecting to SQL Server?

 

[boblarson]

What about an odbc connection from the mdb to the accdb, like connecting to SQL Server?

Doubtful because:

1. The ODBC driver isn't on your computer unless you have Access 2007 installed.

2. Even if you do have both installed, you will likely find that Access doesn't let you connect through ODBC to another Access database.

But feel free to try and report back.