TechRepublic|Forums|Software

Software

General discussion

  • Creator
    Topic
  • October 1, 2004 at 11:26 am #2278399

    Access Locked UP

    Locked

    by jwblaylock · about 18 years, 4 months ago

    I have and end user that has a ACCESS data base that is used for timekeeping for active duty military. User is getting “Access denied” File has been locked for exclusive use” or something like that. The end user has closed the db, my CIO has even moved the files to another drive. Still getting that error message. My question how or what can I look at and try and get the db unlocked.

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • October 2, 2004 at 7:38 am #2723915

      Reply To: Access Locked UP

      by vinnyd · about 18 years, 4 months ago

      In reply to Access Locked UP

      when an access database is open a new file with the same name will appear in the same folder.

      that file is a lock file.

      when access is closed, the lock file should disappear.

      when it does not, you have to manually delete it.

      so look in the folder that access database file is in and delete all files with the same name as the database except for the .mdb file

    • October 10, 2004 at 8:51 pm #3306500

      Reply To: Access Locked UP

      by timfox · about 18 years, 3 months ago

      In reply to Access Locked UP

      Just a few thoughts. (Which version of MS Access?)
      – The Access app might be trying to use a file (shared dll etc) that is already locked on the PC. Shut all other apps down to bare essentials.
      – The Access app might be performing an autoexec code function, when it starts. Use the shift key to bypass.
      Open MS Access first, then open the Access app (exclusively).
      – MS Access might be missing some of its files (or perhaps they are corrupted?). Try re-installing MS Access.
      – Perhaps the user doesn’t have appropriate access to the directory in which the Access app is being stored.

    • November 9, 2004 at 8:35 am #3312306

      Reply To: Access Locked UP

      by suramya · about 18 years, 2 months ago

      In reply to Access Locked UP

      Ask the users to reboot their machines. Sometimes windows forgets to release its locks on a file.

      The easiest way to fix it is to reboot the machines.

    • January 12, 2005 at 8:11 am #3346069

      Reply To: Access Locked UP

      by jwblaylock · about 18 years ago

      In reply to Access Locked UP

      This question was closed by the author

  • Author
    Replies
Viewing 3 reply threads