Bizarre make table query problem

[jkfeagle]

I built my wife a database to use for her work that has worked fine for a good while now. Just yesterday, one of the make table queries began to act peculiar. Suddenly, whenever you try to run it it gives the following error:

"The Microsoft Jet database engine has stopped the process because you and another user are attempting to change the same data at the same time."

This is on a computer at our home so obviously no one else is trying to access it. I have checked and there are no other instances of the database running (I've even rebooted to be sure). I have checked when it was shut down and didn't see a locking file associated with the database. It is a single make table query feeding directly from another table.

As I said, it was working fine for a good while. I'm out of ideas so can anyone help????

 

[jkfeagle]

One other thing to note. A select query pulling the same data works fine. Apparently the problem lies in the table creation?

 

[jkfeagle]

Another update. Code that is used in the database to backup the main data table to another database gives the same error. Hmmm.. I wonder if I'm on to something here.

 

[jkfeagle]

Problem solved. Not sure what it was but running the repair and compact utility took care of it!