Access with non-mdb suffix 1

jimstay · May 22, 2001

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 · May 22, 2001

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 · May 22, 2001

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Access with non-mdb suffix 1

jimstay

Programmer

JoeMiller

IS-IT--Management

jimstay

Programmer

Similar threads

Part and Inventory Search

Sponsor