Sounds like you need transactional replication.
From BooksOnline:
Transactional Replication
With transactional replication, an initial snapshot of data is propagated to Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and...
You should at least split your Access application.
I am assuming that your front end is written in Access, so if you do the split, the data can be migrated up to SQL Server, and you can then link your tables pointing to SQL server as the backend rather than the split
Access database.
Hope this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.