| | |
|
|
|
Multiple logon to Access 97 database |
|---|
| message from Marcel Gruijters on 18 May 2004 |
Hello,
We have a problem with logging on to our database with
several users. If one user opens this database and a
second users this same database on another PC and wants to
close it afterwards he's getting a error message. Then
it's not possible to close Access 97. Then you can only
close this through the TASKMANAGER.
Doed anybody have a solution for our problem ?.
Thanks a million !
Regards,
Marcel Gruijters
Permobil BV, Holland
|
| Nikos Yannacopoulos replied to Marcel Gruijters on 18 May 2004 |
Marcel,
AAlthough you're not very clear on this, do I understand correctly that all
users open the same copy of a monolithic database on a network drive? If
that's the case, then this is most likely the source of your problem (and
more to follow, it's just a matter of time before you're faced with
corruptions).
For a multi-user database, you should use the splitting tool built in Access
to split it to a Front End / Back End scheme, and then leave the Back End on
the network for common access, and distribute a copy of the Front End to
each user. Take some time to browse through the multiuser newsgroup, you'll
find lots of useful stuff.
HTH,
Nikos
"Marcel Gruijters" <m.gruijters@permobil.nl> wrote in message
news:e66b01c43cc0$b4233490$a401280a@phx.gbl...
|
|
Archived message: Multiple logon to Access 97 database (Microsoft Access)
