access 2002 vba compact-repair permissions

[madhouse]

Hi
Am running application.compactrepair (source,dest,logfile) from VBA.
This is available to users, however it appears that only the database owner
user can run it successfully. Is this the case? If so is it possible to pass
the admin user and password to the compactreapir function in vba code rather
than have to give all users owner rights?
thanks in advance
Madhouse.

 

[Joan Wild]

Hi
Am running application.compactrepair (source,dest,logfile) from VBA.
This is available to users, however it appears that only the database
owner user can run it successfully. Is this the case?

Give your user groups open exclusive permission on the database.

 

[madhouse]

Thanks Joan
It might make you laugh to hear I'd been doing this on the front-end mdb
rather than the back-end mdb that I was compacting....oops.