Microsoft Jet database engine message

[Chew407]

I have been trying to figure out the cause of this message I have started getting when I try to run some code that prints reports.

The 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."

This database is on a lap top. It's not connected to a network, so it is accessed by only one person at a time. Any clue why this message keeps popping up?

Thanks,
Chew

 

[smedvid]

I would repair/compact the database first. It could be a bogus error message. U may want to open a new fresh database and import all objects if repair/compact fails. Or restore from a backup. htwh,





Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Zion7]

When a Form/table are open, and you attempt to edit same table/record via code, you may get such a warning.
Check what other processing your code may be doing, prior or during the ErrorMsg event.Or what tables and forms are already open.

 

[Chew407]

I've tried compact and repair and the message still comes up. In my main table I noticed "#Error" appear numerous times in one of the columns. The column it appears in is a joined column, data from another table. Here is the code that I use for the join and that is causing the message:

mySQL = "UPDATE tblPatrolData INNER JOIN tblComments ON"
mySQL = mySQL + "(([tblComments].[KM_Start])=[tblPatrolData].[KM_Start])"
mySQL = mySQL + "AND (([tblComments].[Operator])=[tblPatrolData].[Operator])"
mySQL = mySQL + "SET tblPatrolData.Comments = [tblComments].[Comments]"

Should I be using another method to do this?

 

[easyit]

Hi,

Since you don't seem to use VBA fields/variables etc, why don't you create a regular query and thry to make that work?

easyit

 

[smedvid]

I agree - hard-code the query and give it a test drive first. Just curious - is the Comments field a Memo Data Type?

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Chew407]

Thanks and yes, the comments field is a memo data type. Why?

 

[Zion7]

I believe the reason Steve asked the question, is because you need qualifiers for text fields.

"SET tblPatrolData.Comments = '[tblComments].[Comments]'