access 2002 vba compact-repair permissions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
madhouse said:
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?
Click to expand...

Give your user groups open exclusive permission on the database.
 
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.
 
Back
Top