ACCESS 2000

[Gambler]

I am usuig Windows XP and Microsoft 2000. When i try to bring up my racefile database

RACERESULTS, I get this mess. The Microsoft Jet database engine stopped the process

because you and another user are attempting change the same data at the same time.

All other databases work ok. Can you give me any help.

Thanks ed

[Donnie]

Ed-
Try rebooting your system first. The db engine in mine used to screw up a bit and if I remember properly, simply by rebooting the problem took care of itself. If that does not work you may be able to put your Office disk in and do a repair. If all else fails, uninstall Office and reinstall....you won't lose your db file. It sounds like the problem is in Access and not your db. Good luck!

[Rick]

http://office.microsoft.com/officeupdate/downloads.aspx?CategoryID=CD010224911033&CTT=4&Origin=ES790020041033

Are you up to date on MS service packs for Office XP?

May or may not help.

[Donnie]

yup!! Good call there Rickmiester! Never thought of that one......I wonder how many people coming to the seminar this next week are up to date on their service packs and patches for Office?

[tbrown]

Service paks? Patches?
Uh.......!?!
D'oh!
Guess tomorrow morning is spoken for.

[Gambler]

I tried restarting my computer. No help. I tried downloading XP updates. When I got to the point where I had to insert my Office Disk it did not accept it My disk is an upgrade maybe it wont accept an upgrade. Ill have to do some research. It takes me over an hour to download because I dont have high speed. I now working on getting a price on an high speed.
I think Microsoft will answer question on There support page. Maybe they can give me some advise on why it wont take my CD.
I ran defragment your disk to see if that helped. Is there another things i should run to help my computer run better?

Thanks for helping
ed

[Gambler]

All Products | Support | Search | Microsoft.com Guide

--------------------------------------------------------------------------------
Downloads
MS Product Catalog
Microsoft Accessibility

--------------------------------------------------------------------------------
Servers
Developer Tools
Office
Windows
MSN

--------------------------------------------------------------------------------
Knowledge Base
Developer Support
IT Pro Support
Product Support Options
Service Providers

--------------------------------------------------------------------------------
Search Microsoft.com
MSN Web Search

--------------------------------------------------------------------------------
Microsoft.com Home
MSN Home

--------------------------------------------------------------------------------
Contact Us
Events
Newsletters
Profile Center
Training & Certification
Free E-mail Account
Home Search FAQs Downloads Newsgroups Customer Service

Microsoft Knowledge Base Article - 318882

Need More Help?
Contact a Support Professional by E-Mail, Online or Phone


Search Support (KB)
Access 2000


Advanced Search and Help



Comments?
Provide us with feedback on this article

Support Centers
Access
Access 2000
Office
Office 2000

Other Support Options
Contact Microsoft
Phone Numbers, Support Options and Pricing, Online Help, and more.

Customer Service
For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.

Newsgroups
Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.


Page Options
Send
Print


ACC2000: "The Microsoft Jet Database Engine Stopped the Process" Error Message When You Try to Delete a Record
View products that this article applies to.
This article was previously published under Q318882
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).


SYMPTOMS
If you add a record to a Microsoft SQL Server-linked table and then try to delete that record, you may receive the following 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
This problem occurs if fields with a bit data type in the SQL Server-based database have been left blank. Microsoft Access interprets blank fields as fields that contain Null values, and the Jet database engine does not release them. As a result, the records remain locked and are not available for deletion.
RESOLUTION
To resolve this problem, do not allow Null values, or establish a default value on the fields with a bit data type. To do so, follow these steps:
NOTE: To perform this procedure, you must have the appropriate permissions to modify database objects (db_ddladmin or db_owner).


Start SQL Server Enterprise Manager, and then locate the server where the database is located.
Expand the Databases folder, double-click the database name, and then click Tables.
In the right pane of SQL Server Manager, right-click the table where the field with a bit data type is located, and then click Design Table.
Under Default Value, type either 0 (zero) or 1.

NOTE: To disallow Null values, clear the appropriate Allow Nulls check box.
The information in this article applies to:
Microsoft Access 2000
Last Reviewed: 5/5/2002 (1.0)
Keywords: kberrmsg kbprb KB318882


Need More Help?
Contact a Support Professional by E-Mail, Online or Phone




Contact Us


© 2004 Microsoft Corporation. All rights reserved. Terms of use Security & Privacy Accessibility