Results 1 to 4 of 4
  1. #1
    DPCarusone is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4

    Can Access become a multi-user database?


    I would like for other users on my network to be able to view the Access file while I, or another user, might have the same file or a linked Excel file open. Is this possible? If so, how?

    Thanks in advance.

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    This is possible.

    You will need to split your database into Front End [Queries, Forms, Reports, Modules . . .] and Back End [Tables only].

    You put the Back End on a Network Share and then install the Front end on whichever machines need to use it.

    The Users don't HAVE to have MS Access installed. Read up on installing the Access runtime on the users' machines if they don't have Access installed.

    You can google this information - Microsoft has very good instructions on how to achieve this.

    I have a couple of databases that are split and have multiple users.

    All the best!!

  3. #3
    DPCarusone is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4
    Thank you, Robeen.

    I did this, and now I'm able to open the Access file while having the linekd Excel files open. This is good.

    I still run into the problem that if I already have the Access file open, I can only open the linked Excel files as "Read Only." Can this issue also be solved?

    Thanks again in advance.

  4. #4
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    I bet that is an Excel issue - because I know that sometimes when my programs here at work run and they need to delete an existing spreadsheet - the program will halt if one of my users has the spreadsheet open.

    I don't know of a way to over come that sharing limitation in Excel.

    Do you have the option of importing all your Excel data into Access?

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

Similar Threads

  1. Replies: 11
    Last Post: 07-17-2011, 08:56 PM
  2. Multi-User Access
    By alyon in forum Access
    Replies: 4
    Last Post: 07-13-2011, 11:02 AM
  3. Replies: 12
    Last Post: 06-16-2011, 01:35 PM
  4. Replies: 6
    Last Post: 06-02-2011, 12:27 PM
  5. Design multi user database - avoid simultaneity transactions
    By snoopy2003 in forum Database Design
    Replies: 2
    Last Post: 02-27-2011, 12:03 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