Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006

    Unanswered: Workgroup Permissions and Admin File Lock/or in use

    Hi there, I have an access db that has username/password securities created and works fine but for some reason, I've been getting this error "see attached" I use the same process everytime and this problem has been occuring intermittently but most time I can create the icon for the specific user to launch from their desktops. All workstations are running XP and access ver 03. If I map the drive and authenicate using Administrator creditinals to the where the db resides, I have no problem launching the db, but when I log off and back as the user,the this issues occurs. I've checked permissions from an active directory standpoint and on the db itself and everythings fine. Any help would be greatly appreciated.
    Attached Thumbnails Attached Thumbnails DB_error.bmp  

  2. #2
    Join Date
    Dec 2004
    Madison, WI


    This isn't a solution but may be a work-around if I'm on the right track (otherwise scratch the idea). The attachment basically copies the frontend mdb/mde file, adds the user's loginID, and then opens that mdb/mde file (you just make a few modifications such as location/filename/filetype). My thought is that maybe it might help with your permissions problem by having the main frontend cloned with each user in their own copy. Just put the attached modified vbs script on their desktop. You can edit it with notepad.
    Attached Files Attached Files
    Last edited by pkstormy; 09-27-06 at 00:33.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Sep 2006
    Paul thanks for the reply but this did not work but I finally figured out what my issue was.

Posting Permissions

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