unrecognized data base format
hi,
i had an application written with visual basic 6.0 with ms access data base (dao connection).
it was installed on server using ms windows 2000 advanced server.i have two users,one of them uses windows 2000 & ms office 2000,the second uses windows xp & ms office xp.
some times when the users enter data,suddenly the error
'unrecognized data base format ' appears with one of user
and the database will be damaged.
please can some body help me??
best regards
Software/Hardware used:
Software/Hardware used:
ASKED:
January 30, 2005 3:27 PM
UPDATED:
June 16, 2012 5:34 PM
Answer Wiki:
Jet DB Engine conflicts. The underlying Database engine for Visual Basic is Jet 4.0 (Visual Studio 6.0). this is also the underlying engine for 'Microsoft Access 2000' as shipped and if patched up to date. As patched it is also the same for 'Microsoft AccessXP'. PROBABLE - different patch levels between the three. Start with the 'XP' system and run 'Windows Update' and 'Office Update' then verify the version of Jet running when you open 'Access'. Then do the same with the 2000 system and confirm it is the same version. Last do the update for the DB engine in your application. I hope this helps.
To see all answers submitted to the Answer Wiki: View Answer History.
There are known issues when connecting to Access 2000 on certain localized versions of Visual Basic 6.0 Service Pack 4. This is scheduled to be fixed in Visual Basic 6.0 Service Pack 5. However, this bug is fixed for the English version (North America) of Visual Basic 6.0 Service Pack 4.
You can go for access repair software like Stellar Phoenix Access Recovery. Try the demo version first from here: http://www.repair-access-file.com/ Scan your database to check whether your data is recoverable or not. If you are able to view your database then go for full version to save your data.
It must be access file corruption. In that case you may try next utility to fix such error Access Fix Toolbox