?
Solved

2007 Access Open Exclusive

Posted on 2009-02-19
4
Medium Priority
?
2,182 Views
Last Modified: 2012-05-06
We have gone to the Office Button, Access Options, Advanced, Advanced, and set Default Open Mode Exclusive.  What exactly is that supposed to do or accomplish?  It doesn't do what I was expecting it to do.  I was expecting it to keep anyone from opening the database besides the first person who opened it up.  If that is not supposed to do that is there a way to do that?

Thanks, Pat
0
Comment
Question by:PatKung
  • 2
  • 2
4 Comments
 
LVL 58

Accepted Solution

by:
harfang earned 2000 total points
ID: 23687592
Yes, that is the idea. However, in a FE/BE setup, only the FE is opened exclusively, not the BE. Also, you actually need to open the file from the file menu and choose it in the file picker. Double-clicking an mdb is not affected. Also, if you pick the file from a "recently opened files list", you will get the same open state you used last time (shared or exclusive).

If you need a shortcut to open a given database exclusively, you can use the /excl command line switch. That switch also allows you to open files in exclusive mode from the explorer.

I can't try with version 2007 right now, but it works as one would expect in previous versions.

(°v°)
0
 

Author Comment

by:PatKung
ID: 23688689
At this point it is all in one DB.  So is there a good way to keep anyone from opening the DB while an Admin person is in it because they end up getting the admin access instead of just employee level access?  The DB is on a file server they can all get to.

Open to suggestions.
Thanks, Pat
0
 
LVL 58

Assisted Solution

by:harfang
harfang earned 2000 total points
ID: 23688857
I'm not sure of what you need, and what "admin" vs "employee" level access represents for you. The option you mentioned is about "shared" vs "exclusive" access.

Normally, a database is opened in shared mode: several people can edit the data at the same time. If a user attempts to make design changes or compact the database, the opening mode will switch to exclusive, if he/she is the only current user. If that is not possible, a warning is issued.

To open a database in exclusive mode, you can select that option when opening the database (start Access first, then open the database). You can also create a shortcut for that.

So: a good way to keep anyone from opening the DB while somebody makes design changes is to open it exclusively, or to move it temporarily to a private folder. In Access 2007, the user-level security is no longer supported, so the notion of "admin" vs "normal" users doesn't have the same meaning anymore: everybody is fundamentally "admin", just like for any other Office documents.

(°v°)
0
 

Author Comment

by:PatKung
ID: 23701414
Harfang,
You have pretty much answered my question.
Thanks, Pat
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

850 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