Administrator
administrator at it.glasgow.gov.uk
Tue Jan 28 18:04:57 CST 2003
We repair/compact every night. -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of John Eget Sent: Saturday, January 25, 2003 5:54 AM To: AccessD at databaseadvisors.com Subject: Re: [AccessD] Access Multi-User BE Problems Myke I had the same issue until I elected to use the compact function when the database is closed. have not had a corrupt database in over a year. It is under Tools-Options-General John ----- Original Message ----- From: "Myke Myers" <mmmtbig at bellsouth.net> To: <AccessD at databaseadvisors.com> Sent: Friday, January 24, 2003 4:23 PM Subject: [AccessD] Access Multi-User BE Problems > I've developed an application for a corporate compliance dept that has > grown considerably in the last 4 years. There are about 25 users going > in and out all day. Only a few are entering data. The frontend app is > on the user's PC, with linked tables to the backend (BE). The BE is on > a busy server that handles many other applications. Several users are > coming in via a VPN. > > This database gets locked up and/or corrupted about once a week. This > has become a significant problem. Migrating to Sql Server is in the > distant future, but I need to improve the situation now. > > I'm thinking of breaking out the data tables in the BE database into > separate databases, grouped by departmental function. I would retain > the one frontend application. > > I hope that this would increase responsiveness, reduce down time and > data corruption, and help us identify who/what is causing problems. At > least if one BE database gets corrupted, it wouldn't take out all the > users while it gets fixed. > > Anyone have insight to share? Thanks in advance, Myke > > > > This list sponsored by Database Advisors Inc., a worldwide association > of database developers. > Visit http://www.DatabaseAdvisors.com, the database developers' list portal and support site. > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd