Compress and repair a project "Access 2007"

[Moff]

Hi,
Is there a way to "compress and repair" an Access 2007 project using MS SQL
Server 5.0 Express with VBA code ?
Thank!

 

[Alex Dybenko]

Hi,
not sure this is right want to do such task, but I think you can. You can
start Access.Application object in sql server store proc and then run
CompactRepair method.

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