Compact and Repair Access Database

[mrsbean]

I want to find some code that will compact and repair an Access database located on a remote web server. The web server does not have MS Access installed on it. It runs Coldfusion only (not ASP). Does anyone know of a method whereby I can compact and repair Access databases other than taking them offline and doing it locally where I have the program installed?

MrsBean

 

[GUJUm0deL]

What do you mean "compact and repair"? what's not working with the database now? Do you get errors? Is the code/application not workng as intended? What is happening that leads you to believe that the database needs to be repaired?

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[r937]

compact and repair is a normal, frequent, necessary task for managing access databases

it frees up wasted space, fixes broken tables, etc.

in addition, resets all autonumber seeds to 1 ;-)

and no, i know of no way to do this without the access runtime module

r937.com | rudy.ca

 

[GUJUm0deL]

r937, ahhh. I haven't used Access in ages.

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[mrsbean]

Thanks for your input ... I know there is a way to do this with ASP, but I'm wondering if even that method depends upon having the Access program or runtime installed? Knowing that one could do this with ASP (compact and repair from code) made me think it might just be possible in Coldfusion or some other programming language.

MrsBean

 

[philhege]

You could issue a command-line statement from a batch file.

Once again, you need exclusive use so YMMV.

 

[GUJUm0deL]

Why not perform the clean-up task early in the morning or when the peak usage of the site is really low (like 3AM on a Tuesday morning)?

Put a "site under routine maintance" message, perform the task and re-up the site.

____________________________________
Just Imagine.

http://www.imajinarts.com