Security problem for the user that does the backups

[Newman]

[Resolved] Cannot compact my database

I have a user that has the rights to compact the database. I gave it these rights:
db:Open/Run and Open in exclusivity
tbl "MSysAccessObjects": Modify
(Both on Back-end & Front-end)

But it keeps on telling me that it cannot compact the db 'cause it doesn't have the right to bring modifications to the table "MSysAccessObjects".

I gave it admins' right for now, but I'd like to change this as soon as possible.
PS:
This user is used by a vbscript via the TaskManager at night.
Using OfficeXP (the db is in 2k format) & Win2K over a Novell network.

Thank you!

 

[Newman]

I have new trouble with this old database.
As explained earlier, I gave admin rights to that virtual user to get rid of the error message.
Since I didn't find any other solution, I left it that way. Now, three years and a half later, I received a call from the same customer telling me that the database was getting to big. I went to take a look at it and found out that now it doesn't compact even with the Admin rights. Now the message says that the MSysAccessObjects table already exists.

I would appreciate if someone can point me to a possible solution.
Thank you!

 

[boblarson]

If it won't compact, then you might want to try to import everything into a new shell database. It would probably do it good anyway.

 

[Newman]

I was afraid that I would have to do it.
Thank you!