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

[Rocky Smolin]

If multiple users are using the same front end on the server then that could
very well be your problem.

I suggest that you move the front end to your local machine, and give
everyone who should have access to the data a copy of the front end on their
local machine, and then delete all copies of the front end from the server
to insure that no one tries to run the front end on the server.

And BTW, you know that even when the front end is on the server, a lot of
stuff is passing between the server and your local machine anyway. So any
glitch in the network can still hose your database.

HTH


Rocky Smolin
Beach Access Software
760-683-5777
www.bchacc.com
www.e-z-mrp.com
Skype: rocky.smolin
 


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

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.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com