Question Multiple Users

[Shannon3778]

How can I make a warning pop up when a user tries to access a database that another user is already in??

 

[spikepl]

Perhaps you'd like to explain what the purpose of this would be?

 

[Shannon3778]

Of course... I have a database that multiple users will be using (entering in data on forms, running reports, etc) occasionally at the same time. It seems that if more than 1 person is using the data base the data being entered, is not saving. My manager has requested that when a user opens the database, if another user has it in use, that a warning message appear...

 

[spikepl]

So you have an Access application that doesn't work the way it was supposed to, and you want to pop up a message, which people will or maybe will not remember, that when they enter data that the system is supposed to save but it doesn't?

If my description is correct then this does not sound like a good idea. Is it not possible to fix the application? You can always make it a single-user application, so that only one person can get in at any one time.

 

[Shannon3778]

I'm new to Access... but that's exactly what I want!! How do I do that??

 

[spikepl]

You forgot to state which of the two options you want.

 

[Shannon3778]

Sorry... the option of making it a single user so that only 1 person can be in it at a time.

 

[spikepl]

For 2007: Press the coloured blob in the upper left corner of Access. Then Access options->Advanced->Default open mode->Exclusive

 

[Shannon3778]

Got it! Thanks!!

 

[spikepl]

Pat is of course right, in that using the half-baked application as a single user may not necessarily cure the issue. Shortcuts of this sort tend to come back and bite you, so fixing the app would be a better course of action.

 

[Shannon3778]

Forgive me if this is an ignorant question, but if I haven't split the database, and the users all go to the same file location to open it, how would someone connect to the wrong BE?