?
Solved

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
8
Medium Priority
?
524 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:krd0829
  • 4
  • 2
  • 2
8 Comments
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 23712441
Yes with linked tables Jet needs a reference to establish the lineage of the record - i.e. to determine if it's been updated since editing began / is currently locked.
It manages well enough - but if you include a TimeStamp column in your SQL Server table then it allows an immediate determination of the record's state by the local engine.
Hence you should be able to perform your deletion without the virtual conflict.
(When you've altered the schema of the server table you should always then refresh / relink the table in your Access FE).
Cheers.
0
 
LVL 85
ID: 23712444
If you close all your forms/reports etc, can you then delete the record?

Can you delete a record on the form?
0
 

Author Comment

by:krd0829
ID: 23713043
I can update the table fine but not the records saved from either of the forms. I can open the table inside the database and add new records directly into the table and delete those fine enough, but I cannot edit or delete the records saved from either of the forms. That is when the error occurs. I had already included a timestamp field, and updated the linked table. I even removed it and reimported the table from SQL, but am still having problems.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 23713104
OK - and you don't have any Bit fields which allow Null and have no default value?
0
 
LVL 85
ID: 23713170
<OK - and you don't have any Bit fields which allow Null and have no default value>

My next question ... just had a battle with this one ...
0
 

Author Comment

by:krd0829
ID: 23713842
I have 6 bit values that allow null values, but none of them are being used from inside the form. They were left overs from when the table was used inside a different database. They auto default to 0.
0
 
LVL 44

Accepted Solution

by:
Leigh Purvis earned 2000 total points
ID: 23714408
Jet interprets Bit fields as Booled (Yes/No) and by its definition Booleans cannot be Null (which isn't consistent with the ANSI definition as I recall).
If you ensure that all have a value (i.e. update to 0 if they are currently Null) and disallow Nulls on the column, relink and then try again see how you go.
0
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 23714416
Booled?  What happened with my fingers there? :-s
Boolean, naturally.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question