Posted by Mike Easter on 12/27/05 04:02

Mike Easter <username@domain.com> wrote in
news:Xns9738B2FCEE7D4usernamedomaincom@216.196.97.136:

> I've built a web application that uses MySQL to store data, PHP as a
> web front-end, and Microsoft Access 2000 as an administrative
> front-end. I prefer to have Microsoft Access as my administrative
> front-end for convenience and security (the web portion of the
> application is relatively small).
>
> At times I need to empty my MySQL tables from Microsoft Access, and
> the performance is awful. I would prefer to use TRUNCATE for speed,
> but this isn't available in Microsoft Access (as best as I can tell).
> Neither is OPTIMIZE, and I would like to compress my tables from
> Microsoft Access if possible.
>
> Has anyone else been in my situation? Are there any clever workarounds
> that will permit me to trigger TRUNCATE/OPTIMIZE queries from Access?
>
> Any help/opinions appreciated.
>

For those curious about the answer, I actually found help in Microsoft
Access Help under "stored_procedure." Specifically, there is very good
documentation on "Send commands to an SQL database using a pass-through
query," which permitted me to send a TRUNCATE command through an Access
query. Because TRUNCATE is a combination of a table drop and create, I
don't even need the OPTIMIZE command. Talk about an improvement in
performance! Those DELETEs were killing me!

[Back to original message]