Misleading Error When Deleting a Record in MS Access

[whdyck]

(Previously posted to Reports section, incorrectly. Sorry.)

I'm using MS Access 2003.

I have a form that displays in datasheet view. When I select a record and hit my keyboard's Delete button, I see the following 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.

This error *always* appears when deleting any record from this form. After clicking OK on this error, if I refresh the form, the record in question has indeed been deleted.

We use an Oracle back-end, and I have tried dropping the associated triggers and refreshing the table links, but the error message persists.

Some web pages suggest database corruption, but if I Compress and Repair, I still have the problem.

Any other ideas of where to look?

Any help you can give would be appreciated.

Thanks.

Wayne

 

[James Dudden]

I am not familiar with Oracle but found the same problem when linking to an SQL backend. This link may help you too:

http://support.microsoft.com/kb/318882

 

[missinglinq]

Does the Table have a Primary Key? Can you Add/Edit Records in the Form?

Linq ;0)>

 

[whdyck]

I am not familiar with Oracle but found the same problem when linking to an SQL backend. This link may help you too:
http://support.microsoft.com/kb/318882

This was not quite the issue, but it got me working down a path that led to the fix.

I'm still not sure what *caused* the problem. However, the form's recordsource (query) had a join to an Oracle view that used a lot more tables than necessary, some with outer joins. (The view was initially created for something else and was just used because it had the data needed by this form.) Anyway, I revised the form's query, exchanging the "weighty" view for a couple of simpler LEFT JOINs to Access linked tables, and now the delete works without complaint.

Bottom Line: Not sure what caused it, but sometimes the Jet engine is just fussy, and trial and error gets the job done.

Thanks.

Wayne