MS Access 2000 corrupt's databases

[Hannu]

Hello.

We have about 20 users in our Access databases. Sometime databases
corrupts and are not available. I have to correct them. It is not
nice, because you have to ask every user to close database, because
other wise correcting is not possible.
We have 100 Mt Cat 5 ethernet and some of the users use database via
Citrix servers.
Why databases corrupts and is there anything I can do to this problem?

Hannu

[Wayne Morgan]

There are some things that can be done to minimize the problem. First, make
sure the have the most current updates and service packs for Office, MDAC,
Jet, and your operating systems. These are free downloads from Microsoft's
web site. Next, make sure each local user has a front-end file on their
computer, with a back-end file containing just the tables of data as a
back-end on a network share. Also, make sure the users always close Access
properly before they exit a session or shut down their computers.

For more information on preventing corruption, you will find some good tips
here.

http://members.iinet.net.au/~allenbrowne/ser-25.html

--
Wayne Morgan
MS Access MVP
"Hannu" <ha***************@niiralankulma.fi> wrote in message
news:e6**************************@posting.google.c om...

Hello.

We have about 20 users in our Access databases. Sometime databases
corrupts and are not available. I have to correct them. It is not
nice, because you have to ask every user to close database, because
other wise correcting is not possible.
We have 100 Mt Cat 5 ethernet and some of the users use database via
Citrix servers.
Why databases corrupts and is there anything I can do to this problem?

Hannu

[Tony Toews]

ha***************@niiralankulma.fi (Hannu) wrote:

We have about 20 users in our Access databases. Sometime databases
corrupts and are not available. I have to correct them. It is not
nice, because you have to ask every user to close database, because
other wise correcting is not possible.

For more information on corruption including possible causes, determining the
offending PC, retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm