Access DB on Mapped drive

[Amit]

Hello there,

I have a situation where we need to transfer data from Sqlserver database to
an Access database on hourly basis.
These databases have to be on separate machines.
This access database is used across 3-4 locations as a backend for a
client-server application.

I have been able to map the access database drive on the sqlserver machine
and then made the access database a linked server. I plan to run the queries
on the sqlserver to copy data to access tables.
I was just wondering if there is a better solution available for this
problem and if there are any potential problems that we could face later on
when we go live.

Thanks for your advise.

AJ

 

[aaron.kempf]

use Access Data Projects instead of copying the data around all the
time.

much much simpler setup.

store a user's table on the serverside if you must.

-Aaron