Access 2000 Error :The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
Posted on 2009-02-23
I am running Access 2000 for my forms, reports, queries etc and pull in linked tables from SQL server to store the data. I currently have two forms in a database that are saving the recordsets in a SQL table. The data is saving fine, but when I try to delete a record out of the SQL table from within access it gives me the error message The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. I have other forms and SQL tables inside this database that are working fine. The only time I see the error is when I try to delete from within Access. I can log on to the table inside of SQL and delete fine. No one is currenly using this side of the database or saving into this table so I know there isn't a user confict. Any thoughts on how to fix the problem would be much appreciated.