<div>
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<br />
<br />
Rob
</div>


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

<div>
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?<br />
<br />
Some email filters will trap .mdb file extensions, since the file can contain VBA code, as a potential threat.<br />
<br />
AW
</div>


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

<div>
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.<br />
<br />
Rob
</div>


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

<div>
<div class="content wysiwyg-content">
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&gt;Get External Data&gt;Link tables I don't get an option to connect to .adb files.
</div>
</div>


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.

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.