Jet Engine stopped ??

[onemulligan]

I am using Microsoft Access 97. I have a database and when I try to make a
change on one of the entries I get this message. "Microsoft Jet Engine
stopped the process because you and another user are attemting to change the
same data at the same time." I am the only user on my computer but must have
clicked something incorrectly. In the notes section it says #error. If I
try to take that away the above message appears. All of my other entries
work fine. I would appreciate some help. Thank you

 

[Susie DBA [MSFT]]

uh if your database isn't reliable enough then you shoudl move to SQL
Server

sorry

 

[Tony Toews [MVP]]

I am using Microsoft Access 97. I have a database and when I try to make a
change on one of the entries I get this message. "Microsoft Jet Engine
stopped the process because you and another user are attemting to change the
same data at the same time." I am the only user on my computer but must have
clicked something incorrectly. In the notes section it says #error.

You have a corrupt memo field in that record.

Can you rekey that record? If so I'd try that and then delete the record. If not
See the Corrupt Records in a Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corruption/corruptrecords.htm

Do you have Jet 3.5 SP3 installed? I suspect you don't.

Jet 3.5 SP 3 - msjet35.dll - 3.51.3328.0

Look in the \Windows\System or \WinNT\System32 or similar directory for the above
files. Then right click on the file >> Properties >> Version.

Updated version of Microsoft Jet 3.5 available for download
http://support.microsoft.com/kb/172733

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[onemulligan]

Hi Tony, Thank you so much for the reply. I think the solution may be over
my head. I hired someone to originally do the database for me and I use it
for my clients. I will try to follow your instructions and get back to you
if I can make it work. Regards, Brenda

 

[Tom Wimpernads]

Dude

fire those Access retards and find someone that knows SQL Server

a database that randomly corrupts is not business-ready