How do I recover a corrupt .mdb file

[Happy Face 29]

Got a shared doc we're trying to open and get the error:

 

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

 

Tried decompiling....get the same error.

 

Tried "compact & repair"....get the same error.

 

Microsoft help says....

 

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).

 

1. Start SQL Server Enterprise Manager, and then locate the server where the database is located.

2. Expand the Databases folder, double-click the database name, and then click Tables.

3. 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.

4. Under Default Value, type either 0 (zero) or 1.

 

NOTE: To disallow Null values, clear the appropriate Allow Nulls check box.

 

http://support.microsoft.com/kb/318882

 

But i wouldn't know if i've got SQL Server Enterprise Manager. Is it standard?

 

Edited October 8, 2010 by Happy Face

[Ruler of Planet Houston 1]

Well how do you normally edit your database(s)? I would presume SQL server enterprise manager is just another graphical interface for managing SQL databases? It sounds to me like you just have to set a default value for that table column

[Phil 6]

The KB suggests Access can be managed via the SQL server admin console. So i'd guess it's an optional add-on tick box when you installed access. If you can't find the CD, give Express (the free SQL server admin console) a try.

 

http://www.microsoft.com/downloads/en/deta...b8-5a0f62bf7796

Edited October 8, 2010 by Phil

[Ruler of Planet Houston 1]

sql server manager/management studio is just the gui for connection to sql servers and managing them/running queuries and the like

 

That's what I thought. So whatever way he Normally mucks on with his tables, he should have a method for setting a default.

Edited October 8, 2010 by Ruler of Planet Houston

[dionysus 0]

Got a shared doc we're trying to open and get the error:

 

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

 

Tried decompiling....get the same error.

 

Tried "compact & repair"....get the same error.

 

Microsoft help says....

 

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).

 

1. Start SQL Server Enterprise Manager, and then locate the server where the database is located.

2. Expand the Databases folder, double-click the database name, and then click Tables.

3. 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.

4. Under Default Value, type either 0 (zero) or 1.

 

NOTE: To disallow Null values, clear the appropriate Allow Nulls check box.

 

http://support.microsoft.com/kb/318882

 

But i wouldn't know if i've got SQL Server Enterprise Manager. Is it standard?

 

 

Dont know if this is still a problem but SQL Server is not a home user software package. Its used by IT professionals on a server environment.

 

If your sitting at home and using MS Access or something, then your best bet is restoring from a backup on your computer. (if you have one)

[peasepud 59]

Have you tried importing the tables into a new blank database? that could get you your data back.