By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 897 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

I have an error message that says" This record has been changed by another user since

anoble1
100+
P: 223
This record has been changed by another user since you started editing it....

This happened on 2 particular records. The rest of the records would let me edit. So, I went to the tbl where the record lies, I started manually typing in something then saving it; it came up with the same error message. It only gives me 2 options, not 3. Copy to clipboard, or drop changes. No-one is in the database except me. I just have the tables open. I examined an identical record in the database, they looked exactly the same except for different numbers. But when I put something in the box, it let me, when I tried the other record it didn't let me.

Can someone help?
Feb 11 '10 #1
Share this Question
Share on Google+
8 Replies


P: 99
As no one else has answered you, I'll stick my neck out (as I'm also a 'Newbie'!)

I've had this error when I have code behind a form that is modifying the same table(s) as the form's record source. The built in form operations (save/next etc) believed my code operations were "another user". I think it can also happen if you have two forms open at the same time and both are using the same table (or a query based on a joint table and some others). If the problem crops up after the code has bombed and you've had a 'end/debug' message box, then you can usually get it to forget about the 'other user' by closing and reopening the database!

But I'm sure soon an 'expert' will sort this for you ... hang in there!
Feb 13 '10 #2

nico5038
Expert 2.5K+
P: 3,072
Do you have code or macro's "behind" this form?
If so, can you post it here ?

Nic;o)
Feb 14 '10 #3

anoble1
100+
P: 223
Need help again. Well, when I open up the tables and I try to enter anything in that column it wont let me and throws up this write conflict. It is only on this one record also. It does it every now and then on different records.
Aug 3 '10 #4

nico5038
Expert 2.5K+
P: 3,072
Check the foreign keys that are present in the table.
Is one of them referring to a deleted value in a related table ?

Nic;o)
Aug 3 '10 #5

anoble1
100+
P: 223
The keys look like they are fine. Well, the column was blank. Now when I try to input data in it. It throws up that error message.
Aug 3 '10 #6

nico5038
Expert 2.5K+
P: 3,072
Do you have defined referential integrity for the foreign keys ?

Nic;o)
Aug 3 '10 #7

NeoPa
Expert Mod 15k+
P: 31,186
It sounds like Juliet has a pretty good understanding of the problem. Access is under the impression that someone/thing else has the record open for update. There are various possible reasons for this, but open tables, queries, forms, reports or even, within your code somewhere, recordsets can be your problem.

Another thing that can complicate the issue is whether the table is Front-End / Back-End (FE/BE).

A last thing to look at is the options set up in Access to handle multiple access. These can be found at Tools / Options / Advanced.

It's almost impossible for us to tell you what is causing your particular issue without direct access to your whole setup, but if you can close all open connections across your network and then delete any related LDB files if any are left, the problem will probably go away.
Aug 3 '10 #8

anoble1
100+
P: 223
I closed out the network connections and I did a compact and repair and it automagically let me input data.

Thanks!
Aug 3 '10 #9

Post your reply

Sign in to post your reply or Sign up for a free account.