Greetings!
I'm working on an all-Access 2002 application (no SQL Server or anything like that). Occasionally I'll get the following error when Access tries to save my data: "The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time". Responses are OK and Help. If I go to help, it tells me this is error 3197. The problem only happens sporadically, so I can't nail down a specific circumstance that will always cause it to happen.
I can guarantee that I'm the only user in the database at the time, since this is my development copy where it's happening, and it's stored on my personal network drive where no one else has rights (except other admins, and I know they're not messing with my files). The production version of the app only has two authorized users who can get into it, and they've gotten the same messsage on occasion when one of the users was physically out of the office. So I'm positive this has occurred when only one user was in the database.
I saw thread 701-122269 where somebody had a database on their hard disk (again guaranteeing single user circumstances) and was getting the same error, but it didn't help me. The reply referenced another thread, 181-122291 that talked about the problem being related to using certain data types with SQL Server as a back end. So I don't think that applies to me.
About the only other thing I can think of is that I am linking to tables in other Access databases. Our main business management app is written in Access, and that's where the customer master, product master, etc. all live. My application links in the customer master, but nothing in my application modifies the master tables. Our policy is that no bolt-on app is allowed to change data in the master files, that's only allowed through the business management app. There is no way to create a read-only database link that I've found, so it's possible that a developer in datasheet view in my app could change one of the master tables. But the problem is occuring when I'm using my forms, which don't provide any way to edit the master tables. Just in case there was some conflict with the linked tables, we created shortcuts for all the master databases and linked through the shortcuts, which one of my colleagues tells me can help solve multi-user Access database issues. But the problem still happens on occasion.
Any ideas greatly appreciated.
Dale Beitz
dale.beitz@agreliantgenetics.com
I'm working on an all-Access 2002 application (no SQL Server or anything like that). Occasionally I'll get the following error when Access tries to save my data: "The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time". Responses are OK and Help. If I go to help, it tells me this is error 3197. The problem only happens sporadically, so I can't nail down a specific circumstance that will always cause it to happen.
I can guarantee that I'm the only user in the database at the time, since this is my development copy where it's happening, and it's stored on my personal network drive where no one else has rights (except other admins, and I know they're not messing with my files). The production version of the app only has two authorized users who can get into it, and they've gotten the same messsage on occasion when one of the users was physically out of the office. So I'm positive this has occurred when only one user was in the database.
I saw thread 701-122269 where somebody had a database on their hard disk (again guaranteeing single user circumstances) and was getting the same error, but it didn't help me. The reply referenced another thread, 181-122291 that talked about the problem being related to using certain data types with SQL Server as a back end. So I don't think that applies to me.
About the only other thing I can think of is that I am linking to tables in other Access databases. Our main business management app is written in Access, and that's where the customer master, product master, etc. all live. My application links in the customer master, but nothing in my application modifies the master tables. Our policy is that no bolt-on app is allowed to change data in the master files, that's only allowed through the business management app. There is no way to create a read-only database link that I've found, so it's possible that a developer in datasheet view in my app could change one of the master tables. But the problem is occuring when I'm using my forms, which don't provide any way to edit the master tables. Just in case there was some conflict with the linked tables, we created shortcuts for all the master databases and linked through the shortcuts, which one of my colleagues tells me can help solve multi-user Access database issues. But the problem still happens on occasion.
Any ideas greatly appreciated.
Dale Beitz
dale.beitz@agreliantgenetics.com