• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2205
  • Last Modified:

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

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
Rob4077
Asked:
Rob4077
  • 2
  • 2
1 Solution
 
Arthur_WoodCommented:
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
 
Rob4077Author Commented:
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
 
Arthur_WoodCommented:
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
 
Rob4077Author Commented:
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now