Creating a link with SQL database to a MDB

  • Thread starter Thread starter Jamie
  • Start date Start date
J

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?
 
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.
 
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.
 
Back
Top