We have a MS Access front end linked to an SQL 2005 database with around 200 tables. The database is setup with merge replication and an issue occurs on the publication database but after the data is synchronised. If a user tries to add a new record
they get an error with #deleted record when trying to add new data into the tables from MS Access. After this first prompt for the deleted record the users can then operate as normal with no error messages and the system functions as normal. Another issue
that occurs, but again only just after the data is synchronised, is that if the user requests to view all of the jobs for a particular client the very first time the search is performed a random un-related job is shown not the expected results, if the search
is run again then it will funciton correctly until the next synchronisation is run.
Our tables have Unique IDs with automatic indentity and GUIDs. We have exactly the same solutions working on MSDE and SQL 2000 and there is no such problem on these system.
Any ideas would be most appreciated.
View Complete Post