Can I link to an .adb file from MS Access 2003?

Posted on 2007-04-11
Medium Priority
Last Modified: 2013-12-05
I am running MS Access 2003 and have a need to read data from another system that is based on an adb format database (I think that's MS Access 97). I know I can create a copy of the adb and either convert or retain its original fomat and access the data from the copy but is there any way that I can link to the tables to read them (I don't need to write to the tables)? When I use the menu path File>Get External Data>Link tables I don't get an option to connect to .adb files.
Question by:Rob4077
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 44

Accepted Solution

Arthur_Wood earned 2000 total points
ID: 18889146
no, ADB files are new with Access 2007, and are a completely new file format which earlier versions of Access cannot read.

Access 97, 2000, and 2003 all use the basic file type MDB (Access 2000 and 2003 can also use ADP as an extension for an Access Data Page - web app)

Author Comment

ID: 18889297
Thanks for that Arthur. Your explanation made me realise that the developer of the application I want to tap into has used an adb extension instead of mdb (for whatever reason). As soon as I explicitly named the file with extension my link worked. Thanks again

LVL 44

Expert Comment

ID: 18891296
he possibly used a different extension to avoid problems with a Virus filter on emails - has he sent you the 'adb' as an attachment to an email?

Some email filters will trap .mdb file extensions, since the file can contain VBA code, as a potential threat.


Author Comment

ID: 18894383
No he didn't e-mail it to me but he possibly does want to have the ability to send it to his clients without the problem you mentioned.


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question