I thought they took away replication in access 2007?
If you look at Allen Browne's tips he says make the backend access
2003 or earlier....
http://allenbrowne.com/Access2007.html#Gone
Microsoft is trying to push everyone to put the data into sql server
rather than access..
Even sql server express can replicate but only as a
subscriber.....e..g. It can only read from and merge data from the
other database.
e.g. The production database can copy form the emailed database and a
copy of the production database be sent back...
But do recommend testing if you want to go this route.
Has anyone else had any luck with sql express replication?
It might just be easier to code for the changes to be updated.
One trick is if it is names and addresses etc, then have a change log
and just using some code to crawl through the changes recorded...
That way you always have a trace anyway of changes no matter what!
If using access 2003 to replicate then....
Just make your application check the version of the access database
and make sure it's the same....
e.g. have a replicate button and put some vba to check.....
Otherwise replication can stuff up your data...
Regards,
Tom Bizannes
Microsoft Office and Database Development
Sydney, Australia
