Can't edit a record in Access 97

  • Thread starter Thread starter Elwood Dowd
  • Start date Start date
E

Elwood Dowd

I'm getting the following message when I try to edit (through form) a
record in my Acc97 database:

Write Conflict
This record has been changed by another user since you started editing
it...

I've found numerous references to this on the web, but it always seems
to involve database that are connect to SQL backends, or maybe were
imported from a SQL source. This one was created in Access 97, and is
not connected to any backend.

Any ideas what could be causing this, and possible solutions?

Thanks,

C
 
I'm getting the following message when I try to edit (through form) a
record in my Acc97 database:

Write Conflict
This record has been changed by another user since you started editing
it...
Click to expand...
Any ideas what could be causing this, and possible solutions?
Click to expand...

Three possibilities:

- There actually is a conflict; this can happen when you have the same
record open twice for editing, for instance in a Form or in code

- There was an abnormal termination of Access which left a "lock"
around in the database's LDB file. This can be resolved by closing
Access and (if there is one) deleting the .ldb file with the same
filename and folder as the database.

- Your database may be corrupt. Try Compact and Repair.
 
Thanks, I'll check these out. the LDB angle sounds promising, as I
know this user has had repeated system crashes over the last few
weeks.

thanks!

C
 
Back
Top