Results 1 to 4 of 4
  1. #1
    swasielewski is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    1

    Problems with Access 2003\2007 and shared drive


    We use a lot of access database at my company. We have been getting a lot of locked files and it seems to proceed the entire network drive becoming unavailable until the server is rebooted. Most of our access is version 2003 and we have about 15 people with 2007. All are set to save as 2003 files. we are getting these locked files multiple times a week, almost daily. I even moved the shared drive onto a raid 5 drive on our 2008 server. Did a complete restore to the drive and shared it out. I thought the original problem was the usb drive but now it is doing it on the new server drives also. Any idea's? Everything should be on the latest service packs. I'm really looking for any clues as to what could be causing this. I have verified rights and all looks good.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If you are talking about MultiUser systems then this article is the best I've found on the subject.

  3. #3
    jase_kross is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Location
    Orange, CA (USA)
    Posts
    7
    Had a similar experience. At work we have a .mdb hosted on a Linux file share. Turns out that on a couple of occasions we were locked out of the database. This issue was elevated to the Server Administrator who had to kill a lock process on the server so that we could open the file. No reboot was necessary just had to 'kill' the process.

    The best explanation that we could come up with was that there was an improper handling of file lock upgrades and downgrades.

    One potential file lock fiasco of this sort could be - Someone opens the database exclusively (for a maintenance task), but for some reason the database was not closed properly and so the exclusive lock would remain in place on the server. The user that opened the database with the exclusive lock would himself/herself be locked out along with the others that try to access it.

  4. #4
    Max D's Avatar
    Max D is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    63
    You can try to use terminal services of 2008 server. If everyone use DB in terminal session, this will eliminate network load, and maybe solve locks problem.

    As a bonus you will have potential ability to use your database over the internet.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating 2003 mde from 2007
    By essaytee in forum Access
    Replies: 2
    Last Post: 12-01-2009, 08:37 AM
  2. Converting Access 2000 or 2003 to 2007
    By AnnaK in forum Access
    Replies: 1
    Last Post: 06-09-2009, 08:40 AM
  3. converting from Access 2003 to Access 2007
    By LawrenceLau in forum Access
    Replies: 6
    Last Post: 11-20-2008, 03:53 PM
  4. Multi Users on shared drive
    By wallen in forum Access
    Replies: 0
    Last Post: 08-25-2008, 08:57 AM
  5. 2007 MDE to be used with 2003
    By Charles Waters in forum Access
    Replies: 1
    Last Post: 07-20-2008, 03:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums