Locking file after one user is in .ADE file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If a 2nd user opens up a .ADE file that is already opened by another user,
you get a message that the database will be read only, and you cannot update
the database.

I have two questions regarding this.

1) Is there code I can place in the database (not sure what function to
place this under) so that if the database is "read only" due to two users in
the database at one time, I can display my own personal message box? Such as
"The database is locked down, try again in 15 minutes".

2) I have my users openeing the database through a remote network connection
called "Citrix Nfuse". I thought this program would allow each user to use
their own "session" on the network, and would prevent this error from
occuring. I was incorrect, as each user is using their own session, but they
all point to the same .ade file, so the 2nd user gets the error "read only".
Is there anyway around this? What I am fearful of, is that I will ge tthe
same thing if I create a VB.Net executible file. How (or even If) does
VB.Net handle having more than one user in a VB.Net executibuel file at one
time?

Thank you,

T.J.
 
Your users cannot update the ADE file, but can change the data.

The first user is opening the file in design mode and hence must have
exclusive access to the file. You should set up a shortcut to your ADE file
with the /ro option to open it in Read-Only mode the first time. Search for
"Startup command-line options" in the Access help to have the full list of
startup options.

Another option would be to make private copy of the ADE file for each user.

S. L.
 
Back
Top