Microsoft Jet Database Engine Stopped/Lost Query

[Guest]

Hi All,

Having lots of weird things happening with my database.

Briefly, when I want to edit a query I get: "The Microsoft Jet Databse
engine stopped the process because you and another user....blah..

Also I wrote a query, and now it doesn't show up when I want to use Word
Letter Merge. I open Word, Open Data Source and my query does not appear,
but other queries that I wrote before this one, does show up.

I do have a few memo fields in my table.

The database is on a network and it is on a shared drive. Two of use access
it and edit the form and run/make queries.

My database has only 13 records, a few queries, and a form. I also have a
macro to input a text file and append the table, with an append query.

I did compact and repair and I got the: MySysCompactError, but I don't
understand what it says: Any help is appreciated!!! How do I find the
error, what should I do now? Thanks!!!!!

ErrorCode ErrorDescription
-1611 Could not find field 'Description'
-1017 Could not find field 'Description'

 

[Guest]

Create a new database. Import all objects from the current to the new.