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

[anoble1]

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?

[julietbrown]

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!

[nico5038]

Do you have code or macro's "behind" this form?
If so, can you post it here ?

Nic;o)

[anoble1]

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.

[nico5038]

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)

[anoble1]

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.

[nico5038]

Do you have defined referential integrity for the foreign keys ?

Nic;o)

[NeoPa]

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.

[anoble1]

I closed out the network connections and I did a compact and repair and it automagically let me input data.

Thanks!