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

MS Access 2000 corrupt's databases

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.