Multiple logon to Access 97 database

  • Thread starter Thread starter Marcel Gruijters
  • Start date Start date
M

Marcel Gruijters

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
 
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
 
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.
Click to expand...

Split the database so that only the data tables are shared from the server.
At the rate you are going, there is sure to be corruption in your future, if
you don't.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304932
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top