[AccessD] Corruption Scenario

MartyConnelly martyconnelly at shaw.ca
Fri Jun 16 13:44:39 CDT 2006


If that doesn't work there are various example vba methods to force out all
the front ends to shut down on command via a switch in a backend table
or during a fixed time period. This would require mods to your FE's.

Lawrence Mrazek wrote:

>Hi Lambert:
>
>Thanks for the feedback. 
>
>We just pushed the backup schedule to execute later in the evening, after
>all of the shifts are gone; hopefully that will fix the problem! 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
>Sent: Friday, June 16, 2006 11:05 AM
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] Corruption Scenario
>
>This could indeed be the cause. In the past I have copied a live backend to
>my local drive and found that the working live file was corrupted. Getting
>all the users to log out and then running a Compact and Repair fixed the
>trouble. I never make such copies during the working day now. My backup
>routine is now scheduled to take place when no users are in the system.
>
>Time to talk to the network admins.
>
>Lambert
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
>Sent: Friday, June 16, 2006 11:20 AM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Corruption Scenario
>
>
>Hi Folks:
>
>I'm trying to troubleshoot an intermittent corruption scenarion and was
>wondering if anyone had any opinions ...
>
>Application is designed in frontend (on users local machine) - backend(
>stored on fileserver) format, using Access XP format for both frontend and
>backend. Corruption occurs when user is editing an existing record.
>
>I just discovered, however, that the network backup is running at the same
>time that these corruption errors have occurred ... Since the backend is
>stored on the network and is included in backup schedule, if the backup hit
>the file while they were editing the record ... Could this be the cause of
>the corruption?
>
>I've run office update, checked to make sure that the jet versions are
>up-to-date. 
>
>Thanks in advance. 
>
>Larry Mrazek
>LCM Research, Inc.
>www.lcm-res.com
>lmrazek at lcm-res.com
>ph. 314.432.5886
>fx. 314.432.3304
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada




More information about the AccessD mailing list