Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Replication (2008)  Replication with MS Access 2007 and Sql Server

Author  Topic  gem1204 Starting Member 9 Posts Posted - 2011-08-02 : 16:01:42 I have a client who currently uses MS Access 2007. His employees us a MS Access application on PDA’s to collect data and then once the data is collected he needs an automated way to enter/update the data in the master database. I know MS Access no longer supports replication and I suggested the possibility of migrating to Sql Server for his master database. Does anyone know if it’s possible to set up replication between MS Access and Sql Server? Can someone recommend a possible solution or point me in the right direction to get the information I need? Thanks