[AccessD] Troubleshooting network issues

Charlotte Foust cfoust at infostatsystems.com
Tue Mar 20 17:42:45 CDT 2007


Is everyone using the same version of Access and/or JetComp?  I have had
problems like this with a flaky router, but that was years ago on a
Novell network.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Tuesday, March 20, 2007 1:37 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Troubleshooting network issues

Compact/Repairs.  The users can usually all get in, but some get issues
with specific error messages when they do specific things, and once
anyone sees these kinds of things, no one can log in, get "BE not
recognized / valid database" kind of messages.

Are you saying that even after a compact / repair that there was a bad
record?  The main Be has probably 150 tables.  I am not going to
"discover"
one specific bad record.


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Tuesday, March 20, 2007 4:16 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Troubleshooting network issues

i.e. starting just
>this morning, suddenly the main database be is getting corrupted, as in

>more than a dozen times today.

Were these 'dozen' corruptions fixed by the repair function...or
restoring the db?

Had a problem a couple of years ago... where db crashed...tried to do a
repair/compact...both failed...finally restored from backup...db ran for
an hour...then crashed again.

Turned out that the backup had a single record that was corrupt(memo
field I think), but didn't immediately impact the performance...it would
run for about an hour...then just crash(hard).

I used a combination of sorting and misc functions to locate the
offending record/field and loaded good records into new db.

Just thought I'd share.

Good Luck,

Mark A. Matte


>From: Jim Lawrence <accessd at shaw.ca>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Troubleshooting network issues
>Date: Tue, 20 Mar 2007 13:02:17 -0700
>
>Hi John:
>
>I have run into many similar issues in the past. In my case the 
>problems were around flaky NIC cards and in one case it was an IT guy, 
>in the evenings whom would keep rebooting the server to test some 
>backup
scripts.
>Naturally not everyone had logged out of the Access application at the 
>end of the day.
>
>We used a packet-analyzer to spot the problem... not necessarily what 
>the product is designed for but its ability to keep an ongoing 
>transaction file of network traffic proved invaluable. There are some 
>similar open-source products out there that will do the same thing.
>
>HTH
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
>Sent: Tuesday, March 20, 2007 12:12 PM
>To: 'Access Developers discussion and problem solving'; 'Discussion of 
>Hardware and Software issues'
>Subject: [AccessD] Troubleshooting network issues
>
>One of my clients is apparently having network issues, i.e. starting 
>just this morning, suddenly the main database be is getting corrupted, 
>as in more than a dozen times today.  The common wisdom is that 
>corrupted BEs is a network issue - NICS, cables, switches, routers etc.
>Does anyone have any experience tracking down such a problem, any 
>recommendations for tools that would watch for intermittent network 
>connections, troubleshooting suggestions for trying to isolate the 
>offending piece of the puzzle?
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>--
>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

_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft
Office Live!
http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/

--
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



More information about the AccessD mailing list