By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Access 97 - Multiuser problem

P: n/a
Hello all,

We are using A97-SR2 and XP.

The problem is (simplified):
- We've got an A97 db (say "a97.mdb") on a file server (say "S").
- Many persons need to access this database at a same time (say "P1", "P2"
and "P3")
- P3 is different from P1 and P2 only in the fact that he is in the
administrators group on his PC.
- P1 and P2 can only open the a97.mdb if nobody has opened it (including
themselve: they cannot open it twice at the same time)
- P3 can open a97.mdb at any time without restriction.
- If P1 or P2 open a97.mdb the P3 open it, they can continue to work without
any problem.
- No error message is generated, nor at screen neighter in the system or
application log. Nothing is appening. Double-clique the file... nothing.
- P1, P2 and P3 have write/exec/read on both the a97.mdb file and the
directory where it is stored.
- As expected, a97.ldb is always created when one of them open a97.mdb for
the first time.

Well. I hope it's clear. Anybody can tell me how to solve this problem, and
give concurrent access to the DB?

Thanks

Yannick
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
P1 and P2 don't have their default set to open exclusively, do they? Check
the Advanced tab under Tools | Options.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Yannick Turgeon" <no****@nowhere.com> wrote in message
news:B8*******************@news20.bellglobal.com.. .
Hello all,

We are using A97-SR2 and XP.

The problem is (simplified):
- We've got an A97 db (say "a97.mdb") on a file server (say "S").
- Many persons need to access this database at a same time (say "P1", "P2"
and "P3")
- P3 is different from P1 and P2 only in the fact that he is in the
administrators group on his PC.
- P1 and P2 can only open the a97.mdb if nobody has opened it (including
themselve: they cannot open it twice at the same time)
- P3 can open a97.mdb at any time without restriction.
- If P1 or P2 open a97.mdb the P3 open it, they can continue to work
without any problem.
- No error message is generated, nor at screen neighter in the system or
application log. Nothing is appening. Double-clique the file... nothing.
- P1, P2 and P3 have write/exec/read on both the a97.mdb file and the
directory where it is stored.
- As expected, a97.ldb is always created when one of them open a97.mdb for
the first time.

Well. I hope it's clear. Anybody can tell me how to solve this problem,
and give concurrent access to the DB?

Thanks

Yannick

Nov 13 '05 #2

P: n/a
Are they all trying to open the same mdb file on a server? You might want
to consider splitting the db into front and back ends and giving each user
their own front end. Also, all users need read/write/execute/delete
permissions to the parent folder.

HTH - Keith.
www.keithwilby.com

"Yannick Turgeon" <no****@nowhere.com> wrote in message
news:B8*******************@news20.bellglobal.com.. .
Hello all,

We are using A97-SR2 and XP.

The problem is (simplified):
- We've got an A97 db (say "a97.mdb") on a file server (say "S").
- Many persons need to access this database at a same time (say "P1", "P2"
and "P3")
- P3 is different from P1 and P2 only in the fact that he is in the
administrators group on his PC.
- P1 and P2 can only open the a97.mdb if nobody has opened it (including
themselve: they cannot open it twice at the same time)
- P3 can open a97.mdb at any time without restriction.
- If P1 or P2 open a97.mdb the P3 open it, they can continue to work
without any problem.
- No error message is generated, nor at screen neighter in the system or
application log. Nothing is appening. Double-clique the file... nothing.
- P1, P2 and P3 have write/exec/read on both the a97.mdb file and the
directory where it is stored.
- As expected, a97.ldb is always created when one of them open a97.mdb for
the first time.

Well. I hope it's clear. Anybody can tell me how to solve this problem,
and give concurrent access to the DB?

Thanks

Yannick

Nov 13 '05 #3

P: n/a
Well, I solved the problem addind "S" IP to the "Trusted sites" list:
http://windowsxp.mvps.org/networkfile.htm

I don't really know why it's working. When P1 and P2 were opening a97.mdb,
they was getting a warning message, not P3. We've got use of it. Probably
this security check was causing some kind of error when trying to open an
already opened db.

Thanks to those who replied.

Yannick
"Yannick Turgeon" <no****@nowhere.com> wrote in message
news:B8*******************@news20.bellglobal.com.. .
Hello all,

We are using A97-SR2 and XP.

The problem is (simplified):
- We've got an A97 db (say "a97.mdb") on a file server (say "S").
- Many persons need to access this database at a same time (say "P1", "P2"
and "P3")
- P3 is different from P1 and P2 only in the fact that he is in the
administrators group on his PC.
- P1 and P2 can only open the a97.mdb if nobody has opened it (including
themselve: they cannot open it twice at the same time)
- P3 can open a97.mdb at any time without restriction.
- If P1 or P2 open a97.mdb the P3 open it, they can continue to work
without any problem.
- No error message is generated, nor at screen neighter in the system or
application log. Nothing is appening. Double-clique the file... nothing.
- P1, P2 and P3 have write/exec/read on both the a97.mdb file and the
directory where it is stored.
- As expected, a97.ldb is always created when one of them open a97.mdb for
the first time.

Well. I hope it's clear. Anybody can tell me how to solve this problem,
and give concurrent access to the DB?

Thanks

Yannick

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.