I have a client who currently uses MS Access 2007. His employees us a MS Access application on PDAs 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 its 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?