Limiting Access to One Person at a time 1

[chris3366]

I have a MS Access Database on a network and want to limit access to one person at a time. The Exclusive feature on the Advanced Tab under options doesn't work. By going thru the Access program to start a database and selecting open exisiting file does work but I am looking for speed and ease of use...As most of you know most users are lazy and do not follow directions very well. I was hoping to try it through code if possible. (Access 2000) is what I am using.
Your help is appreciated and respected.
Thanks
Chris

 

[chiph]

What problem are you trying to solve by only allowing one person in at a time?

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[chris3366]

I have some workflow data that gets exported to an Excel doc for the user to work off of. But what is happening is before an update can be generated stating these items have already been assigned somebody else selects work and gets work already assinged to somebody else and the database thinks the second person has items different than what they have on their Excel Doc. By limiting access to DB to one person at a time I can stop this duplication in exporting to Excel...at least that is my hope. Hope this explaination helps.

 

[koala15]

Sounds very much like a "classical" serialization challenge.

Some (maybe many) people will disagree but because MS Access by nature uses bound forms and controls, it gives the coder only limited control over serialization in a multiuser environment.

If you were to use a stand alone VB app and use ADO to get your data then you could lock the data by page and by using appropriate time function ensuring that the whole system app does not lockup because a user walked away from a form wanting a resonse.

Greg.

"Life is full of learning, and then there is wisdom"

 

[chiph]

You could write a query that copies the data to a extra table, which is what you'd point Excel at instead of the main table. The query to populate this extra table would execute fairly quickly, since the source and destination of the data are within the database itself, thus reducing the chances of a user modifying the data while the export is in progress.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[bjd4jc]

You can also specify the open mode in a shortcut. In your shortcut the target must point to access.exe and then pass the full path of the database and the put /excl after the database path. This will open in exclusive mode.

 

[chris3366]

bjd4jc,
I have tried that but I keep getting an error message stating that the folder doesn't exist. I am sorry I have never modified shortcuts before..can you be a very specific.
Here is the path to the database -
\\NHHKSFS01\nhcqa\AuditAgingList
And the path to the MSACCESS.EXE
C:\Program Files\Microsoft Office\Office\MSACCESS.EXE

In the shortcut there is a Target Field and a Start in Field. I appreciate your help and your patience in this matter. Thanks!!

 

[chris3366]

bjd4jc,
I have tried that but I keep getting an error message stating that the folder doesn't exist. I am sorry I have never modified shortcuts before..can you be a very specific.
Here is the path to the database -
\\NHHKSFS01\nhcqa\AuditAgingList\AuditAgingList.mdb
And the path to the MSACCESS.EXE
C:\Program Files\Microsoft Office\Office\MSACCESS.EXE

In the shortcut there is a Target Field and a Start in Field. I appreciate your help and your patience in this matter. Thanks!!

 

[bjd4jc]

Here is what I would put:

Target:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "\\NHHKSFS01\nhcqa\AuditAgingList\AuditAgingList.mdb" /excl

Start In:

\\NHHKSFS01\nhcqa\AuditAgingList\

 

[chris3366]

bjd4jc,

That is PERFECT!!! Thanks So Much!!!!