Compacting Access 97 databases using code

[Guest]

Hi,

I want to be able to compact a database by calling a function after the
tables have been updated.

I would use the normal method but the tables are updated by a schedule and I
want the database to get compacted after this happens (about 3am every day
when Im not at work).

Does anyone know any code to help make this possible please?

Thanks in advance for your help.

Maver1ck666

 

[Alex Dybenko]

Hi,
have you tried dbengine.compactdatabase nethod?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

I have but it returned an argument not optional error. Unless I have made a
schoolboy error somewhere?!?!

Now I understand this could be difficult as the database will still be open
when it tries to compact so would it be easier to have the code in a batch
file which is run by a scheduler after the database has closed?

 

[Alex Dybenko]

Yes, if database is opened then you can do either scheduled compact, or
perhaps on start - make a batch file which will first compact database and
then run it

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Thanks for your quick reply.

This is where I become a noob im afraid. What code would I need to put in
the batch file please?

Kind regards,
Maver1ck666

 

[Guest]

Also, something I forgot to mention is I dont want to create a copy of the
compacted database if that makes sence?!? I just want the original file
compacted.

 

[Rick Brandt]

Also, something I forgot to mention is I dont want to create a copy of the
compacted database if that makes sence?!? I just want the original file
compacted.

Compacting ALWAYS creates a new file. The menu action from within the GUI just
hides that from you. You just need to delete the original and then rename the
new file (which is what the menu action does).

 

[Alex Dybenko]

Hi,
first you can start msaccess.exe with /compact option (see Startup
command-line options in help)
then copy compacted file to old location
and then start msaccess.exe with this MDB

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com