[AccessD] Database is in an unrecognizable format...

[Bob Walsh]

Both the front end and the back end are on a network drive in the same directory.

The database and the backup db that the repair creates are both hosed.

Everything is up to date.

I guess I am going to have to go back to editing on my local drive and copying to a network drive so that it gets backed up and I can access from multiple machines.

Frustrating to lose half a days work from this. I actually felt like I was getting ahead today...
Silly me...

From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, February 7, 2018 8:29 PM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Database is in an unrecognizable format...

[Attn: This is an external email.]

Is the back end on a server and the front end on your local machine where
some transaction is getting hosed 'over the wire'? That's one of the common
causes.

So when this happens the database is unrecoverable?

Is it happening fairly regularly - 1-5 times a week? Or a long intervals?

If you are running the back end on a server could you move it to your local
drive temporarily to rule out the network as a cause?

If you're on a server, try switching ports on the server's router - maybe
the one you're using is a bit wonky.

Also, you can try replacing the cable, and/or replacing your NIC. Those are
all elements of the system any one of which could be causing a problem.

Software: Everything up to date with the latest patches? DAO or ADO?

Rocky


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob
Walsh
Sent: Wednesday, February 07, 2018 8:08 PM
To: 'Access Developers discussion and problem solving
(accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>)'
Subject: [AccessD] Database is in an unrecognizable format...

I am randomly getting this error while I am in the database, editing it.
It destroys the database, even though it says it is repairing it and making
a backup.

Any thoughts on why I am getting this error?

Bob

________________________________
HealthInsight is a private, nonprofit, community-based organization
dedicated to improving health and health care, with offices in four western
states: Nevada, New Mexico, Oregon and Utah. HealthInsight also has
operations in Seattle, Wash., and Glendale, Calif., supporting End-Stage
Renal Disease Networks in the Western United States. The information and any
materials included in this transmission may contain confidential information
from HealthInsight. The information is intended for use by the person named
on this transmittal. If you are not the intended recipient, be aware that
any disclosure, copying, distribution, or use of the contents of this
transmission is prohibited. If you have received this message in error,
please inform the sender and delete all copies.
--
AccessD mailing list
AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>
http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
Website: http://www.databaseadvisors.com<http://www.databaseadvisors.com>

--
AccessD mailing list
AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>
http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
Website: http://www.databaseadvisors.com<http://www.databaseadvisors.com>

________________________________
HealthInsight is a private, nonprofit, community-based organization dedicated to improving health and health care, with offices in four western states: Nevada, New Mexico, Oregon and Utah. HealthInsight also has operations in Seattle, Wash., and Glendale, Calif., supporting End-Stage Renal Disease Networks in the Western United States. The information and any materials included in this transmission may contain confidential information from HealthInsight. The information is intended for use by the person named on this transmittal. If you are not the intended recipient, be aware that any disclosure, copying, distribution, or use of the contents of this transmission is prohibited. If you have received this message in error, please inform the sender and delete all copies.