Need help with Microsoft Jet database error

[moes123]

I have a database currently accessed by several users over our network, we encountered "Run-time error '3043' which was rectified on it's own. A couple of hours later a user complained of another error in which it asked to repair the database, users exited and i run the compact and repair option which went through sucessfully and users continued working,an hour after this 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.
I am stuck here and i cannot access any of the data even to copy to another database,
can someone please assist with this error and possible solutions, thanks in advance
moes.

 

[Hap007]

Hi Moes,

You need to make a backup copy of that Access mdb file ASAP.

Sounds like you may still have Access running from when you did the compact and repair, or someone else has a version of MS locking the file.

Here is what I would do.
1) Have everyone exit Access (Your Application)
2) Rename the MS Access backend on the server.
Note: If you can not rename, then someone still has the file open
If this is true, you may need to shut down the user PCs and worst case you might need to re-boot the server.
3) Once renamed, the copy the renamed mdb file to your Local PC.
4) Open on your Local PC and do a Compact and repair.
If you cna not do a compact/repair than you may need to download the more robust utility from Microsoft to repair the DB.
5) Now copy the compacted/repaired version back, from your PC, to the server
6) Rename the server file to the correct name.


Hope This Helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[moes123]

Hello Hap,

Thanks for your reply, however the 2003 mdb database has not been split, therfore it resides in a shared drive so users can access.

Any more suggestions.....

 

[PHV]

Any more suggestions....
Split the db ASAP and put the FE on each user's local drive.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Hap007]

Hi Moes,

Well, 2 thoughts.

1) Follow everything I mentioned in the first email, except, after you compact and repair, open up a code window and compile the database (db)

2) Then, when times permits (ASAP) and as PHV suggests, split the app into a frontend and backend. Place the backend on the server and the Frontend on each user's PC.

Good Luck,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[moes123]

Hello PHV,

Aparantly i cannot split the db at the moment, once i or any of my users try opening the db the error: "the microsoft jet database The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time" comes up, i cannot access any of the data, the window does not show up even when F11 is pressed.

 

[MazeWorX]

sounds like the db is corrupt. Having forms,queries and code with tables will cause this. Try importing all of the objects into a new db container. Recompile then split the data from everything else. The data becomes the Back end then distribute the compiled front end to the users local machines

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work