Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Compact the user level security

    Thank You.
    Last edited by accessman2; 04-27-06 at 20:48.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you probably need to compact the workgroupfile when no one (including you) has the workgroup file open.

    I'd suggest opening a copy of access using another workgroupfile (probably best done as a command line switch /workgroup="newworkgroupfile" - I think thats the correct form but check on the msdn site. or make sure that no other users are using access with that same workgroupfile.

    it may make more sense to do the process out of normal working hours, so it could be sensible to inclide it in a batch process, failing that you may have to wokr out of hours to fix it if its an oneoff problem.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •