Import or Link Tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My database is in a MS SQL Server which I want to update when I update
anything in the *.mdb...Would I want to import these tables or link these
tables? Thanks for the help!
 
HMote said:
My database is in a MS SQL Server which I want to update when I update
anything in the *.mdb...Would I want to import these tables or link
these tables? Thanks for the help!
Click to expand...

Link. If you import you are making local *copies* and your updates will not
show up on the server.
 
You link to the MS SQL Server using ODBC connection. The MS SQL Server
connection can not be read only in order for you to update data.
 
Back
Top