What type of changes are you making? What version of SQL are you using? I believe that ADP's store forms in the Access file and not on SQL, query's and tables are all controlled and changed on the SQL server.
Are the changes gone if you open the file 10 minutes later?
Is there any file sync applications setup on your machines?
I have been experimenting with ADP's but haven't placed anything into production. I use Access 2003 as my frontend and SQL 2000 and SQL 2005 as my backend. All of my data is stored on the SQL server and my queries/forms/reports are stored in my Access database. I haven't seen any problems like the one you described at all.
Are the changes gone if you open the file 10 minutes later?
Is there any file sync applications setup on your machines?
I have been experimenting with ADP's but haven't placed anything into production. I use Access 2003 as my frontend and SQL 2000 and SQL 2005 as my backend. All of my data is stored on the SQL server and my queries/forms/reports are stored in my Access database. I haven't seen any problems like the one you described at all.