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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conneting to SQL server, Need advice 3
Basic Link Tables Question 6
SQL Server 6
Criteria for importing tables from a odbc link 2
Transfer data from any mdb file to sql server? 1
Can't link to MS SQL Svr 2005 table (#deleted) 8
multi-level table linking 2
Linked Split table file from QB ODBC not updating 9

Back
Top