RE: 1 User In BD At A Time

Tech-Archive recommends: Fix windows errors by optimizing your registry

-Many thanks to you all. I see I have a lot to learn about access. I
thought I was a simple lock or unlock toggle....

Two other thing. I enter data into my form and close the form. When I
reenter the form it orders my entries by the PK. Can I not order the form by
PK and just have the order the entries by entry order?

And is it possible to move the RECORD: (counter at the bottom left) of the
form to the top right of the form.

Thanks again for all of your help.

SKK

"Dale Fye" wrote:

As Jerry says, why?

There are times, where I want to restrict access to the backend while I am
doing some maintenance or for some other reason. When this is the case, I
have a field [InMaintenance](Yes/No) in a table in the backend of the
database.

I have a function that allows me to change this value between Yes and No
whenever I want. Then, when a person logs onto the front-end, the splash
screen checks to see if that field is True or False. If it is true, I popup
a screen that says the database is in maintenance and advises them to check
back later, then closes the application. When I'm done doing my maintenance,
I change it back to No, and the other users are allowed access to the
database.

I actually take this one step further and have the Splash screen (hidden
after they have entered the application) timer event check that value every
couple of minutes. This way, if someone else is logged in, and I need to
force them off, I can do so elegantly.

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"skk" wrote:

I would like to have only one user to be able to open the DB at a time.
Right now I can have the DB open (working) and another user can open the same
DB and work in it at the same time. I went into TOOLS/OPTIONS/ADVANCED/ and
changed the open mode to EXCLUSIVE but multiple users can continue to open
the DB at the same time.

This is a 2003 Access DB

Can I have only one user able to open the DB at a time?


Thanks for all help.


.

Relevant Pages

  • RE: 1 User In BD At A Time
    ... PK and just have the order the entries by entry order? ... where I want to restrict access to the backend while I am ... doing some maintenance or for some other reason. ... a screen that says the database is in maintenance and advises them to check ...
    (microsoft.public.access.gettingstarted)
  • RE: repeated conversion of data summarized into rows and columns
    ... the database name, table name and field names I used in the code. ... Dim currentUser As String ... ' Column Pointer to work through Hour entries ... Dates and to the HoursDates table and containing a usage entry. ...
    (microsoft.public.excel.misc)
  • Re: Pathname to access and usernames in shortcut
    ... >> network drive (for maintenance reasons initially, ... >> using usernames but no passwords. ... change their passwords within the access database (they won't know how ... >> gets the current username from the system and then calls access (via the ...
    (microsoft.public.access.security)
  • Re: Using Visual Basic Net as front end - Access as back end
    ... really powerful machine to run the database front-end, ... I originally wanted to have the backend located in the California ... I could not have just one backend database it took Florida ... Report as the report writer and Access as the ...
    (microsoft.public.access.formscoding)
  • Re: Why does splitting a mdb make it slower?
    ... In one form that opens as a continous form, the data looks like it is being repainted as it displays...you can see each row being created quickly. ... I created a table on the backend called KeepOpen. ... performance when opening the main database and opening tables and forms, by forcing the linked database to remain open." ... The folder name is 8 characters in length. ...
    (comp.databases.ms-access)