Access with non-mdb suffix 1

[jimstay]

I am writing an interface to a purchased software product. It uses Access, but the database suffix is not .mdb. I have no problem opening the database.

I want to link the table into my application When I try to add the table with "get external data" it says it doesn't recognize the file type. So I tried creating an ODBC data source, and it says I can't open an Access database with ODBC.

Any suggestions ?

Thanks, Jim

 

[JoeMiller]

When you go to link the table type in the name of the file rather than using the browser to find it. Even though it doesn't appear because the window only shows .MDB's you can still pull up the file by typing in the full name.
Joe Miller
joe.miller@flotech.net

 

[jimstay]

Joe,

Thanks for the quick reply. When opening the database I told it to look for all file types ( *.* ), but didn't think to just type the name when linking.

Now I'm ready to roll.

Jim