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

[Jim Dettman]

Some other items:

1. Only run a hard connection, don't use wireless.
2. Make sure the NIC card doesn't have any diagnostic protocol's loaded.
These disconnect from the network to run tests, then re-connect.  Most apps
don't notice, but Access does.
3. Turn off all power management on the NICs.   You don't want the card
going to sleep.

Jim.
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
RANDALL R ANTHONY
Sent: Thursday, February 8, 2018 9:23 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Database is in an unrecognizable format...

Bob,
We've had similar issues and it looked like anti-virus checkers on the
network were blowing up our FE's on a regular basis.  Once the network team
excluded the .mdbs from the checkers, it greatly reduced the episodes.

HTH.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Thursday, February 08, 2018 4:06 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Database is in an unrecognizable format...

Hi Bob

I've seen exactly the same.

Always copy the file to a local folder, and edit it here.
When finished, copy back to the network folder.

I've never seen the issue since I implemented that method.

I guess the cause is caching of the file either on the server or locally (or
both) that in the end may drive Access into uncertainty and forces it to
give up.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Bob
Walsh
Sendt: 8. februar 2018 05:41
Til: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Emne: 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 

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