p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Re: Unrecognised Database Format


Message #1 by "N. Gilman" <ngilman@a...> on Thu, 13 Jun 2002 20:46:33
> Hi!

> I have recently installed an Access 2000 database at a customer's site 
and 
a> bout twice a week they are receiving the 'Unrecognised Database Format' 
e> rror message. Each time the database repairs successfully but I need to 
s> top this from happening so much. Please could I have any thoughts on 
the 
f> ollowing:
1> . I have experienced similar problems twice before (out of many 
databases 
t> hat I have installed) and both times the problem was solved by 
i> dentifying and changing a faulty network card. The problem is that the 
n> etwork card behaved fine for everything else except Access.
2> . I am not convinced that this customer has a sensible network 
c> onfiguration but I do not know enough about network systems to advise 
t> hem sensibly at the moment. Their 'server' (it's actually just a peer-
to 
p> eer network) is running Win95 and the users are running a variety of 
o> perating systems such as Win95, Win98, Win2000 etc. Does this sound bad?
3> . Each user has a local front-end and the data sits on the back-end 
W> in95 'server'. There are about 7 concurrent users and one thought I 
have 
i> s to update the 'server' operating system to Windows 2000 server or 
even 
N> T 4.0 and perhaps install SQL server and convert the back-end to SQL. 
D> oes this sound sensible and would it solve the problem?

> Many thanks,

> Paul
Message #2 by "N. Gilman" <ngilman@a...> on Thu, 13 Jun 2002 20:51:04
Paul,
I also get the same problem a couple of times a week on Access 2000.
However, we have Windows 2000 Server on our 'server', and Win 2000 on all 
other machines on our peer to peer network.  Also our other network 
software (accounting packages etc) don't seem to have the same problems. 
There is something else going on. I have no answer for you otherwise, 
except that it seems to be a widespread problem with Access databases. 
Maybe XP would be better? Or rewrite the application in Visual Basic 6/VB 
Net??  There is software you can buy which will convert your app to VB6.
Nicola
Message #3 by "John Ruff" <papparuff@c...> on Thu, 13 Jun 2002 16:09:40 -0700
This typically happens if the user also has Access 97 installed on their
computers and they opened one of their Access 97 dbs.  Windows will
automatically try to open your Access 2K dbs with the msaccess.exe that
was last used.  Access 97 can be uninstalled and this will resolve the
problem, or create a shortcut on your customer's desktop to the Access
2K dbs and fully qualify the shortcuts.  In other words, tell the
shortcut which msaccess.exe to use.

 

John Ruff - The Eternal Optimist :-)
Always Looking for a Contract Opportunity

xxx.xxx.xxxx
9306 Farwest Dr SW
Lakewood, WA 98498 



-----Original Message-----
From: N. Gilman [mailto:ngilman@a...] 
Sent: Thursday, June 13, 2002 8:47 PM
To: Access
Subject: [access] Re: Unrecognised Database Format


> Hi!

> I have recently installed an Access 2000 database at a customer's site
and 
a> bout twice a week they are receiving the 'Unrecognised Database 
a> Format'
e> rror message. Each time the database repairs successfully but I need 
e> to
s> top this from happening so much. Please could I have any thoughts on
the 
f> ollowing:
1> . I have experienced similar problems twice before (out of many
databases 
t> hat I have installed) and both times the problem was solved by
i> dentifying and changing a faulty network card. The problem is that 
i> the
n> etwork card behaved fine for everything else except Access.
2> . I am not convinced that this customer has a sensible network
c> onfiguration but I do not know enough about network systems to advise
t> hem sensibly at the moment. Their 'server' (it's actually just a 
t> peer-
to 
p> eer network) is running Win95 and the users are running a variety of
o> perating systems such as Win95, Win98, Win2000 etc. Does this sound 
o> bad?
3> . Each user has a local front-end and the data sits on the back-end
W> in95 'server'. There are about 7 concurrent users and one thought I
have 
i> s to update the 'server' operating system to Windows 2000 server or
even 
N> T 4.0 and perhaps install SQL server and convert the back-end to SQL.
D> oes this sound sensible and would it solve the problem?

> Many thanks,

> Paul

Message #4 by "Enzo" <enzaux@g...> on Fri, 14 Jun 2002 08:57:47 +0800
	We have the same problem paul.  In my case I think the main culprit is the OS differences between the "server" and the
workstations.  I have no proofs yet but that's only possiblity I can see.  But right now the database is ok for almost two weeks
and I have done nothing to prevent the error from happening...this is really weird the error occurs unpredictably.

	Nicola-->  really is there a software that would convert my Access App to VB App?  Wow kewl!!!  I was trying to switch to vb
although Access is good.  The only thing that I don't want with Access is that it can be compiled to an .exe :(

Enzo :)

-----Original Message-----
From: N. Gilman [mailto:ngilman@a...]
Sent: Thursday, June 13, 2002 8:51 PM
To: Access
Subject: [access] Re: Unrecognised Database Format


Paul,
I also get the same problem a couple of times a week on Access 2000.
However, we have Windows 2000 Server on our 'server', and Win 2000 on all
other machines on our peer to peer network.  Also our other network
software (accounting packages etc) don't seem to have the same problems.
There is something else going on. I have no answer for you otherwise,
except that it seems to be a widespread problem with Access databases.
Maybe XP would be better? Or rewrite the application in Visual Basic 6/VB
Net??  There is software you can buy which will convert your app to VB6.
Nicola




  Return to Index