Access and SQL server

  • Thread starter Thread starter xiaowei
  • Start date Start date
X

xiaowei

We would like to link some Access database tables in SQl
server. This sounds not a normal way.

But currently we have to do something like this. We just
bought SQL server installed on a windows web server for
some online applications to collect data. And our
internal database are Access applications. We know
finally we need to convert our current Access
applications to a server/client structure. But for now,
we want to synchronize the SQL server tables and our
internal Access tables. Is there a way to link Access
tables from SQL server? Our internal network is netware.

How can this be implemented?

Any ideas would be appreciated
 
Sure.
SQL Server supports linked servers.
Then you can write SQL Server queries against the Access tables using 3 part
names.

You could just as easily do it the "normal" way and link the SQL tables to
Access.
Then you could write append queries from Access to SQL Server.

Finally,
Keeping them in synch manually is sure to fail.

Why not just upsize the tables to SQL Server, delete the Access tables and
link to the SQL tables?
This is usually Step1 in converting from Access to SQL Server. (At least for
me.)
It gets the data to the server and the Access app should still work.
(Maybe not as fast as before since you introduced network latency but it
should still work.)
The Access app needs to be optimized to wrok with SQL Server - get a book
like Mary Chipman's to see what I mean.
 
Back
Top