1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access Database Sharing

Discussion in 'Business Applications' started by Dubby20, Jul 2, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. Dubby20

    Dubby20 Thread Starter

    Joined:
    May 21, 2012
    Messages:
    13
    Hi,

    I have created a new database and would like to share it among my team. However, when another user opens it, it says file already in use. How can I get the database to allow multiuser access.

    I need it so that when information is entered it gets updated in real time on other users machines as well.

    Please let me know if you have any solutions.

    Regards,

    Archie
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    What version of Access are you using?
    Is it on a "Server"?
    Have you set the Folder it is in to be "Shared"?
    Is the database opened by a Desktop Shortcut?

    The reason for the questions is that most versions of Access automatically share a database.
     
  3. Dubby20

    Dubby20 Thread Starter

    Joined:
    May 21, 2012
    Messages:
    13
    I am running Access 2007. It is currently in a shared folder which the users have full control over. And no it is not accessed by the desktop, just from the folder at the moment.
     
  4. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    Does the database contain "Memo" fields?
     
  5. Dubby20

    Dubby20 Thread Starter

    Joined:
    May 21, 2012
    Messages:
    13
    No, it is a call logging form. There is just one form with a sub form in it, running from a table.
     
  6. Dubby20

    Dubby20 Thread Starter

    Joined:
    May 21, 2012
    Messages:
    13
    I have put it on the desktop of one of the users and they can open it whilst i have mine open. But the database isn't updated in real time; any changed made on the users system isn't showing on mine.
     
  7. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    It must be on a shared drive, computer or network folder for real shared updating.
    Normally problems revolve around permissions for the folders/drives/networks etc.
    You also have to share the .ldb file that Access creates when opened, see this article.
    http://support.microsoft.com/?id=299373
     
  8. Dubby20

    Dubby20 Thread Starter

    Joined:
    May 21, 2012
    Messages:
    13
    How would I share that file (wher is it stored when the database is open?)
     
  9. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    Normally it is in the same folder as the database.
     
  10. Dubby20

    Dubby20 Thread Starter

    Joined:
    May 21, 2012
    Messages:
    13
    The only file that opens up has the file extension: .laccdb

    Is that the file you are reffering to?
     
  11. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    It may well have changed for Access 2007, but that is the file, it contains the names of the people in the database, if it can't be shared new users can't be added.
     
  12. Dubby20

    Dubby20 Thread Starter

    Joined:
    May 21, 2012
    Messages:
    13
    How would I see who is added to it. Please see attached screenshot of folder and if you can let me know where to go i'd appreciate it.
     
  13. Dubby20

    Dubby20 Thread Starter

    Joined:
    May 21, 2012
    Messages:
    13
    please see attached
     

    Attached Files:

  14. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    You can use Word to read the file, but you have to select "All files" first.
    Of course if you can't open it it means it is locked.
     
  15. rubystatu

    rubystatu

    Joined:
    Jul 19, 2012
    Messages:
    1
    Dear Friend,
    There are some reasons which may damage your MS access database such as virus infection, software crash, accidental shutdown of system, unrecognized format of database, corruption of storage media etc. These issues are easy to overcome by using third party software of access database repair.there are so may software which help you to get your data back one of them is Kernel for Access Database repir you can download this software from here accessrecoverytool.net
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1059370

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice