|
I have a corrupt database. If I open it in MS Access, MS Access offers to repair it, and it succeeds.
How can I do that with code? On a machine where MS Access is not installed.
I know from trying it that JRO.JetEngine.CompactDatabase does NOT work.
In...
Started by Corey Trager on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The ....
Command-line switch for opening a .mdb file:
/compact and search for the JetComp.exe utility, which will attempt to repair and compact your MDB without opening the file.
To compact and repair a corrupt database file.
|
|
I was inserting data into a MS Access database using JDBC-ODBC driver. The blank mdb file was 2KB. After populating this database, the size grew to 155MB. Then I was deleting the data. But I found the size of mdb remains the same as 155MB. I don't get...
Started by Dean on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
To do Utilities ->
Compact and Repair....
On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
Use the Compact and Repair utility:
Backup your database, as there is a bug in Access 2007 that may.
|
|
For a small project I need to utilize a simple database with very light requirements: few tables, no more than few thousands of records in total, 2 or 3 users. I am working in .NET environment.
As a database server (even those Express editions) seems ...
Started by petr k. on
, 13 posts
by 13 people.
Answer Snippets (Read the full thread at stackoverflow):
An Access database on a network (MDB)
Microsoft Access Performance FAQ
When going with a network share an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file this isn't too much of a problem....
|
Ask your Facebook Friends
|
We distribute an application that uses an MS Access .mdb file. Somebody has noticed that after opening the file in MS Access the file size shrinks a lot. That suggests that the file is a good candidate for compacting, but we don't supply the means for...
Started by Corey Trager on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
Well it really matters! mdb files keep increasing in size a compacting method through your ....
Can also recover from any 'unrecoverable' compact and repair problems with a minimum of data loss decide to add this functionality to your app.
|
|
On Sat, 21 Feb 2009 07:33:01 -0800, djmarcus <djmarcus@discussions.microsoft.com
I am experiencing the same issue. It creates Database1.accdb and leaves the
original alone.
[I'm running Win/XP with the latest updates. I am the admin for the system...
Started by djmarcus on
, 7 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
Compacting creates a new file (Database1.accdb, Database2.accdb....
Steele" <NOSPAM_djsteele@NOSPAM_gmail.com
Perhaps you don't have the correct permissions on the folder where the accdb
file exists .
On Sat, 21 Feb 2009 12:51:20 -0500, "Douglas J .
|
|
Hi all,
I need to compact and repair an Access 2007 .accdb database file. I know that JRO.JetEngine can do this with .mdb files, but I need to repair the newer version 2007 format by code.
Any suggestions?
EDIT:
Here is the thing: I found that I can use...
Started by TheAgent on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you're working from outside Access.
No repair operation as a separate command since Access 2, and a repair happens only if the database engine determines during the compact that a repair is necessary).
|
|
On Wed, 20 May 2009 03:54:01 -0700, Recovering the mdb <Recoveringthemdb@discussions.microsoft.com
Hi,
I am getting an error while trying to open the mdb. "Microsoft Jet Engine
cannot process the file as the file is locked by some other user"....
Started by Recovering the mdb on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
HTH
--
-Larry-
--
"Recovering the mdb" <.
If everyone is
out of the application and the Filename.LDB remains, try to delete it .
Someone has
terminated their Access session in an MDB abnormally.
|
|
I have an Access application that use the classical front-end/back-end approach. Yesterday, the backend got corrupted for a reason I don't know. So I opened the backend with Access 2003 and access asked me if I wanted to repair the file, I said yes and...
Started by Mathieu Pagé on
, 6 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Never compact a Jet MDB without.
Hidden objects and/or system objects in Tools | Options | VIEW .
|
|
On Thu, 9 Apr 2009 10:32:34 -0400, "Joe" <jbassking@noemail.noemail
Hello all!
Is there a way to get the version of access that a mdb file was created
with? We have a mdb file which became corrupt and can be fixed with a newer
version of Access...
Started by Joe on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
Http://support.microsoft.com/default.aspx it into a new mdb running the version of
Access that is compatible with your front-end application.
The following KB article about how to repair a
mdb file.
|
|
We're in process of creating .NET frontends to our old Access 97 databases. Due to restrictions outside our control we can't migrate the databases to SQL or any other modern database.
However we're having big problems with the IDE. The Server Explorer...
Answer Snippets (Read the full thread at microsoft):
Can see 'Compact and Repair Database' option, click it to Compact and Repair the database.
|
