Compact and repair

[DavidW]

I looked through previous post and seen a few things about vb and
compaction. How would you compact and repair 3 databases with vb code. Can
you close your application and have a temp. database that only runs the
code. If so what would it be

 

[Jonathan Parminter]

-----Original Message-----
I looked through previous post and seen a few things about vb and
compaction. How would you compact and repair 3 databases with vb code. Can
you close your application and have a temp. database that only runs the
code. If so what would it be

Hi David,

try this knowledgebase article
http://support.microsoft.com/?id=158937

Luck
Jonathan

 

[Nikos Yannacopoulos]

David,

In the same newsgroup there is a posting by Kcomer, titled "Compacting DBs",
dated 12/01/04 12:25. See my reply to that one.
That code actually compacts all .mdb files in a given directory, but it can
be modified to read paths and filenames from a table, making it more
suitable for selective compaction.
A separate database just to host the code would do the job nicely.
I have a similar situation with two databases, and used VBA 6.0 instead to
create a small .exe that does the job. It's easier to run but less
efficicent to maintain if target files change (it needs recompilation, as
the files are hard-coded). One might argue that it could be made to read the
files from an Access table, but in that case it would be useless! The
database could also hold the code just as well.

Regards,
Nikos