Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2009
    Location
    Cairo
    Posts
    7

    Why 2 users cant open an access file directly???

    When an access database file is opened. (mdb) ,the other user double click on the file but cant open it. He has to open Msaccess first and open the file from inside the program.

    If the file is not opened , I can double click on the mdb file directly. How can I solve this problem?

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    It sounds like the file is not in shared mode.
    Pls check the option for file sharing chosen. (exclusive mode or not)

    The other solution offered by someone in the internet.
    Quoted as follows:-

    This appears to be an issue after installing Internet Explorer 7. To solve it, you can:

    Go into your Internet Properties
    Security Tab
    Click "Local Intranet"
    Click "Sites"
    Uncheck "Automatically detect intranet network", leave a check in the other three "Include..." checkboxes

    This solves!!

  3. #3
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    The real answer from Microsoft is:
    Due to its own bug.

    The final solution is here:-
    Modify the shortcut
    In the target of the shortcut, include the path of MSAccess.exe.
    Nothing happens or an hourglass appears when multiple users try to open an Access database (.mdb) by using Windows Explorer or a shortcut
    Nothing happens or an hourglass appears when multiple users try to open an Access database (.mdb) by using Windows Explorer or a shortcut

  4. #4
    Join Date
    Feb 2009
    Location
    Cairo
    Posts
    7
    Quote Originally Posted by thhui View Post
    The real answer from Microsoft is:
    Due to its own bug.

    The final solution is here:-
    Modify the shortcut
    In the target of the shortcut, include the path of MSAccess.exe.
    Nothing happens or an hourglass appears when multiple users try to open an Access database (.mdb) by using Windows Explorer or a shortcut
    Nothing happens or an hourglass appears when multiple users try to open an Access database (.mdb) by using Windows Explorer or a shortcut
    How can I include MSaccess.exe in the target??

  5. #5
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    If you make a shortcut for the access file,
    then the shortcut could be adjusted to have
    the full path of access file included in the target of the shortcut.

    For example:
    change the target as:
    "c:\program files\OfficeXP\Msaccess.exe" "d:\mdb\nwind.mdb"

  6. #6
    Join Date
    Mar 2009
    Posts
    3
    Splitting your MDB into a front end and back end,Put the front-end distributed to users, Link tables from back end

  7. #7
    rommelgenlight is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2009
    Posts
    77
    andymark's solution is right. probably you are using one file for all. try splitting your db.

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

Similar Threads

  1. Limiting access to certain users only
    By huskies in forum Security
    Replies: 1
    Last Post: 04-01-2009, 08:18 AM
  2. Can not open File already in use.
    By Wrangler in forum Access
    Replies: 1
    Last Post: 03-04-2009, 09:50 PM
  3. Track users use of Access database
    By booyeeka in forum Programming
    Replies: 1
    Last Post: 02-26-2009, 02:35 AM
  4. SENDING EMAIL MESSAGES DIRECTLY FROM ACCESS
    By Frenchos in forum Access
    Replies: 0
    Last Post: 07-20-2007, 12:51 AM
  5. Replies: 0
    Last Post: 01-19-2007, 07:58 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
  •  
Tech Forums: Microsoft Office Forums