Compacting Database

[Guest]

You should be able to make access compact a datbase before it opens the file
or can this already be done.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...08b17b&dg=microsoft.public.access.formscoding

 

['69 Camaro]

Hi.

or can this already be done.

Of course it can. With or without Access installed on the computer.
Programmatically even. Please see the following Web page for two non-Access
solutions:

http://www.Access.QBuilt.com/html/Gem_tips1.html#Compacting

After the database is finished compacting, execute a Windows shortcut to
open the database.

Also, one can merely open Access, select the Tools -> Database Utilities ->
Compact and Repair Database... menu, navigate to the closed database file,
select this file to compact, name the new file to compact into, then select
the "Save" button to compact. When it's finished, use the File menu to open
the database file.

Or one may use a command-line switch to compact a closed database. For
example, the following command in the Target Property of a Windows shortcut
will use Access 2003 to compact C:\MyDB.mdb (watch out for word wrap, as
this should all be one line):

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\MyDB.mdb"
/compact

Therefore, one could execute a Windows shortcut to compact the database,
followed by executing another Windows shortcut to open the database.

So that's a list four different ways right there. If none of these are
suitable for your situation, then please post back, describing what you need
and what version of Access you have.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.