Solved

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

Posted on 2007-04-11
4
2,097 Views
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.
0
Comment
Question by:Rob4077
  • 2
  • 2
4 Comments
 
LVL 44

Accepted Solution

by:
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)
AW
0
 

Author Comment

by:Rob4077
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

Rob
0
 
LVL 44

Expert Comment

by:Arthur_Wood
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.

AW
0
 

Author Comment

by:Rob4077
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.

Rob
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

808 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