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

Posted on 2007-04-11
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
  • 2
  • 2
LVL 44

Accepted Solution

Arthur_Wood earned 500 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

758 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now