I am running a FE/BE access 2000 database that requires compact and repairing about once a week. I have recently seen utilities online that could automate the compact and repair feature of access to fire off every day. The problem that I am running into is that every time a compact and repair fires off it resets the permission on the backend. My question I guess would be is there anyway that I could set default file permissions that would be set every time a compact and reapir is done. I understand that every time a compact and repair is done a copy of the original file is made and the data imported into this copy, so is there a path to a file that is used in this copy process to set permissions.
Thank you very much for any help,
Michael Oakes
Thank you very much for any help,
Michael Oakes