User rights and "compact"

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

Guest

We have an access database that has a scheduled job to do weekly backups.
Since we changed to Access 2002 (on Win2k), this job (bat file) is "broken".
The user "has no admin rights" to execute the command-line "/compact" Access
command.

What do I need to do in order to allow this person to do the COMPACT, but
not give her admin rights? (Or can that even be done? If I MUST give her
rights, let me know.)

Thanks!
 
compact requires read, write, create and delete rights on the
folder where the database is located. If you are using Access
User Permissions, compact also requires the Access User Permission
'open exclusive'

(david)
 
Back
Top