[AccessD] Message not deliverable

Administrator administrator at it.glasgow.gov.uk
Wed Jan 29 02:51:39 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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd



More information about the AccessD mailing list