PJ_KD
asked on
Access Error 3734
How do I eliminate Error 3734 (The database has been placed in a state by use <name> on machine <name> that prevents it from being opened or locked)?
I would like to avoid splitting the database into a front end and back end arrangement. I have checked the sharing option on the machines and those are Shared vs. Exclusive. I have tried Compact and Repair on the database. I have created a new blank database and then imported the original database components into the new database but the 3734 error persists. Thank you for your assistance. This database is only shared by 2 people.
I would like to avoid splitting the database into a front end and back end arrangement. I have checked the sharing option on the machines and those are Shared vs. Exclusive. I have tried Compact and Repair on the database. I have created a new blank database and then imported the original database components into the new database but the 3734 error persists. Thank you for your assistance. This database is only shared by 2 people.
Last Comment
I agree. Splitting the database should eliminate (or at least considerably reduce) the occurrence of this error. Also, it makes it much easier for the developer to deliver modifications to the database interface, without affecting the data in the back end.
Splitting your database is also a great way to prevent corruption:
http://www.techrepublic.com/blog/10things/10-ways-to-prevent-access-database-corruption/331
http://allenbrowne.com/ser-25.html
http://www.techrepublic.com/blog/10things/10-ways-to-prevent-access-database-corruption/331
http://allenbrowne.com/ser-25.html
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Is there another approach rather than splitting the database?
AFAIK ... all bets are off until that is done. There are just too many unknowns.
mx
mx
ASKER
OK, I have split the database for test purposes but what goes where? I am assuming the back-end will stay on the server, a copy of the front-end on each user's machice. Is there anything that I need to do to have the front-end of the database know where the back-end of the database is located? (I know that this seems like a silly question but does it make any difference where the back-end and front-end are created orginially for purposes of the front-end knowing where the backend is?)
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
"I am assuming the back-end will stay on the server, a copy of the front-end on each user's machice."
correct.
" Is there anything that I need to do to have the front-end of the database know where the back-end of the database is located?"
Yes. Take the FE 'master' and Link to the BE using the FULL UNC network path ... not mapped drive letters (problematic).
The ... distribute a copy of the FE 'master' to each workstation.
mx
correct.
" Is there anything that I need to do to have the front-end of the database know where the back-end of the database is located?"
Yes. Take the FE 'master' and Link to the BE using the FULL UNC network path ... not mapped drive letters (problematic).
The ... distribute a copy of the FE 'master' to each workstation.
mx
ASKER
Thanks for these suggestions. I will try this again tomorrow and get my users to give it a try to see if it eliminates their issue. After the issue is resolved, I will award the points (Hopefully early this week).
ASKER
Just letting you know that I think that this is fixed based on what you all have advised. I am awaiting my users' signoff that they are good now and then will award points - just didn't want you to think I had forgotten to come back to this.
Appreciate the update ... thx
mx
mx
ASKER
I appreciate the help and the users are now satisfied.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Why? That is the de-facto standard used by all professional Access developers, and the time tested method to minimize multi user issues. And it's very easy to do.
mx