Solved

Avoiding Error 3734

Posted on 2007-03-29
4
575 Views
Last Modified: 2012-08-13
How to I avoid 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 am using a multi-user database in Access 2003 utilizing a form that contains a subform.  The data is in SQL Server 2005 and is linked via ODBC.  The default open mode is set to "Shared" and the default record locking is set to "No Locks".
0
Comment
Question by:DOHMH
  • 2
4 Comments
 
LVL 28

Expert Comment

by:omgang
ID: 18819767
Are all users accessing the same Access database file?  Or do they each have their own copy of the Access file?
OM Gang
0
 
LVL 84
ID: 18819955
In addition to what OM Gang suggested, are other users opening any object (table, form, query, etc) in Design view? If they are, then the suggestions by gang will solve this, but the bigger trouble is allowing users to open objects in Design view. Generally this is a very bad idea and can lead to no end of troubles. Users have no knowledge of data, schemas, etc etc and two simple keystroke combinations (Ctrl+A and Del) can wipe out a table permenantly.
0
 

Author Comment

by:DOHMH
ID: 18822940
All users are accessing the same database file. Users are not permitted to open objects in design view.  Users originally had their own copy of the Access front end, but this problem started when we converted to one centralized front end.
0
 
LVL 28

Accepted Solution

by:
omgang earned 500 total points
ID: 18823147
I'd recommend switching back to a distributed, individual front-end application.  That is the preferred method of deploying an front-end application - whether a native Access back-end or SQL back-end.  I just recently accepted a job to convert a single, stand-alone Access app into a BE/FE app to resolve issues exactly as you describe.
OM Gang
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now