Error Message

[RICKA]

I have an error message poping up when i look at a record

"The microsoft office jet database engine stopped the process because you and another user are attempting to change the same data at the same time"

i do not know how to stop this appearing as there are no other users in the database. i have tried repairing, compacting and copying the database but with no luck.

does anybody have a solution??

Rick

 

[rwilliams]

I did a search through Microsoft and found this article.

It said...

Error Number 3197:
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.
Cause/Problem:

This error typically occurs when a long value column (an OLE or MEMO data-type) has bad data stored in it. Long value columns are typically stored in a separate page from the page that the row is stored in. If a long value column is present in the table schema, the Jet database engine will attempt to read the long value page when reading the row of data. In order to read the long value page, there is a pointer in the row of data. This error is generated when the Jet database engine cannot properly read the long value page from the pointer present in the data row. When viewing a row that exhibits this behavior in Microsoft Access data-windows, the user will typically see the number sign (#) for the entire row.

There's a download in the resolution section and a helpful tip in the references section. I'm not sure if this would be applicable to you because it confused me on the versions. Maybe you can read it and understand more.

Otherwise, I have no idea. Best of luck to you.

 

[RICKA]

Thanks, this showed me that an error had occured in the access program (Not mine) and the quick fix was to copy all the data from the table and overwrite it with a new table, thus deleting the error, all the data was then pasted back in.

Rick