Creating a link with SQL database to a MDB

[Jamie]

Does anybody know how to link from an sql databse to a
microsoft Access Databse? Or is it easier to create a
table in SQL and synchronise the contents? if so how would
you do that?

 

[Van T. Dinh]

Use the menu File / Get External data / Link Tables ...

You can link to SQL Tables and View both of which appear as linked Tables in
your Access database (MDB file).

If your Back-End is MS-SQL Server, you can also use Access Data Project (an
ADP file) and use the SQL Tables in a Client-Server set-up.

 

[Lynn]

What is better to use with MS-SQL a MDB file or a ADP
file?
Thanks,
Lynn

 

[Van T. Dinh]

Personally, I used MDB. Not sure which one is better/more efficient but
there were a number of problems (for me) with ADP in A2K and AXP. May be
the new version A2003 will be different.