Reply from Crazydayz on Jun 24 at 1:49 AM The best thing I have found to recover an Access database is to Create a Blank database and then import the 'Corrupted' database information. This is the best most reliable way to solve your issue. I have had issues that a form gets corrupt and you can't recover it, but datawise I rarely didn't recover it using this method.
I would also suggest using a 'Front end database' as previously stated. Then use links to the database you want to get the information from. When if using code to run queries always Close when not running queries. This should generally make the main database not have .ldb file unless your running a query.
If you have a server I would put the freebee version of SQL on it and create links from access to the SQL database (Import AccessDb into SQL).
| | | ---------------Original Message---------------
From: radhika ghatage
Sent: Sunday, March 18, 2012 10:24 AM
Subject: Restoring Corrupt ACCESS Database
I have a running VB software where database is kept in ACCESS 2000
format. This database has got corrupt,(probably by trying to open a
file which was opened by another user exclusively)
If I try to open the database either by program or by clicking on
the file I get the error no 2147467259 with message 'Microsoft Jet
database engine stopped the process because you and another user are
attempting to change the same data at the same time
Is there any way I can retrieve the data from this file?
Radhika Ghatage |
| Reply to this email to post your response. __.____._ |   _.____.__ |
No comments:
Post a Comment