Results 1 to 14 of 14
  1. #1
    Rockitman31 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    7

    Can't open Access file when it's opened by another


    I don't know what I did to my Access 2007, but when I attempt to open any mdb file that is already opened by another user on out network, Access just ignores me. It won't even attempt to open.
    What is wrong here?

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Not enough info

    Your post suggests that things were working but you don't specify whether they were working with an earlier version of Access, or they were working before you or someone else made some changes (perhaps the the record locking settings?).
    Please elaborate.

  3. #3
    Rockitman31 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    7
    Things were working fine until a while ago. Not sure if I accidently did something to my settings. We are using Access 2007.

    This only happens to me. Other users have no problem opening the myriad of Access files we have out there on the network.

    Again, if the mdb is already opened by another and I then try to open it, nothing happens, Access won't even open up on my screen.

    What other details do you need?

  4. #4
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    A guess

    Quote Originally Posted by Rockitman31 View Post
    Things were working fine until a while ago. Not sure if I accidently did something to my settings. We are using Access 2007.

    This only happens to me. Other users have no problem opening the myriad of Access files we have out there on the network.

    Again, if the mdb is already opened by another and I then try to open it, nothing happens, Access won't even open up on my screen.

    What other details do you need?
    Without getting into specifics, all I can do is guess: Look in Access Options/Advanced/Advanced. See if the settings there are the same as other users. Particularly the first two items.
    Last edited by hertfordkc; 10-12-2011 at 11:14 AM. Reason: spelling

  5. #5
    Rockitman31 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    7
    Quote Originally Posted by hertfordkc View Post
    Without getting into specifics, all I can do is guess: Look in Access Options/Advanced/Advanced. See if the settings there are the same as other users. Particularly the first two items.

    yep, they're the same. I don't get it.

    How bout I uninstall Access and reinstall?

    Will Office let me uninstall only the Access or will it wipe out all Office apps?

  6. #6
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    That is extreme. !!!
    What else might you have changed, e.g. some network settings or permissions?
    Over my head now. Good luck.

  7. #7
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    What happens when you open access first and try to go to the database from the main interface?

  8. #8
    Rockitman31 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    7
    Wow! thanks for that advice, it works!

    If I open Access and then open the mdb in question that is already opened by others it works!

    What does that tell us though as to why I can't directly open these mdbs?

  9. #9
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Hi
    It sounds a though the db has NOT been split.
    If you have a single mdb file that is being used at the same time by multiple users it will become corrupted. Such files should be split in to a Backend and Frontend. The backend holds the tables. The frontend has the forms etc. Each user has a copy of the frontend on their machine and each frontend is linked to the tables in the single backend.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  10. #10
    Rockitman31 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    7
    Not sure what that means, database being split.

    We have 1 mdb that is accessed by 20 users at once. These users, when they open the mdb are presented with the Form that was built for them. They do not see any tables or queries.

    If I wish to open the mdb and not bring up the Form, I hold the shift key as I open the file to give me access to everything.

  11. #11
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by Rockitman31 View Post
    Not sure what that means, database being split.

    We have 1 mdb that is accessed by 20 users at once. These users, when they open the mdb are presented with the Form that was built for them. They do not see any tables or queries.

    If I wish to open the mdb and not bring up the Form, I hold the shift key as I open the file to give me access to everything.
    At the momment up to 20 users are using a single mde file at the same time. Yes?

    What you should have is one mdb file to hold the data tables (Back end).
    Each user should have another mdb file (Front end) which has everything else that the current mdb has except the tables which are in the Back end. Each Front end is then linked to the single Back end mdb file.
    Not doing this is a common cause of database corruption.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  12. #12
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Quote Originally Posted by Rockitman31 View Post
    Wow! thanks for that advice, it works!

    If I open Access and then open the mdb in question that is already opened by others it works!

    What does that tell us though as to why I can't directly open these mdbs?
    No idea. I have seen this behavior before somewhere though for the life of me I can't remember why I tried going through Access first as opposed to clicking on the mdb. It could be that your file associations in windows for mdb files has a conflict of some sort.

  13. #13
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  14. #14
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Glad it worked... To quote Bob:
    If this helped, please click the scales at the top right of this posting

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

Similar Threads

  1. Open excel file in access
    By shanky365 in forum Access
    Replies: 1
    Last Post: 09-11-2011, 03:05 PM
  2. Open a pdf file from Access
    By bginhb in forum Programming
    Replies: 5
    Last Post: 08-17-2011, 02:42 PM
  3. Replies: 3
    Last Post: 12-09-2010, 11:50 AM
  4. Replies: 4
    Last Post: 09-28-2010, 07:04 PM
  5. Replies: 1
    Last Post: 09-27-2010, 10:10 AM

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