Sporadic 3734 error and You do not have exclusive access Error

ions

Access User
Local time
Today, 11:55
Joined
May 23, 2004
Messages
823
Dear Access Expert.

I am sporadically getting the 3734 error and Exclusive message when I go to design mode or try to save an object.

Sometimes everything works as it should and sometimes I get these error messages. I am the only user of the mdb and trying to do development on my local machine.

I have spent the last 2 hours trying to figure this out and I am getting dizzy from it.

I have tried the following.

Decompiling.
Converting to 2003 format from 2000 (Client's environment is now 2003)
Placing the Backend and FrontEnd in seperate folders.
Watching the .ldb files to make sure they disappear.

The database may be corrupt as it's about 11 years old and has had multiple developers over the years. I did import all objects into a new container twice about a week ago.

I did do a little bit of development in 2007 on some of the forms but am now working in 2003 to avoid any corruption.

These problems only seem to occur during development. Exclusive error causes me to lose unsaved work and the 3734 error causes me to have to restart testing as I can't step through code.

Any insight would be appreciated.
 
G'd morning Ions,
I don't know if this will help but, try to convert your project to accdb, check for external resources such as images, files, dlls and activex controls.
Try to identify if it always happens with the same object (form/report/module)
Try in another PC and see what happens.

G'd luck
Estuardo
 
Placing the Backend and FrontEnd in seperate folders.

In split database, you would have 1 BE on a shared server, and 1 FE per user on that user's PC. It isn't clear that you have multiple FE's (1 for each user).

You don't mention a separate backup mechanism. I recommend you keep some backups of your development work. After doing something -- new procedure/revised process --- save the database and document what it really is. If you do get some corruption, you can go back to a recent backup. The impression I have from your post is that you really aren't sure what you are working on; several developers have done a variety of things over time....

Bottom line is you've go to set some sort on benchmark -- a version that you understand. Back it up, protect it. You need more discipline in your procedures.

Work with a copy and make, test, retest your changes. Back it up...

Do some Compacts and repairs to remove some of the bloat/garbage that does happen with development.

Good luck with your project.

More info possibly at
http://www.granite.ab.ca/access/performancefaq.htm
http://www.fmsinc.com/microsoftaccess/performance/linkeddatabase.html
 

Users who are viewing this thread

Back
Top Bottom