Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    Vandacardoso is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    29

    Multiple Users in the same Database

    Hello,

    I need to put my Database to work with multiple users. 1- I already have divide the database; 2- I already have made the file accde of the front-end file; 3- I already have put the two files: back-end and front-end on the network server.
    My problem now is that if I open a Form to register data the other User can't open the same form to add data. Can someone help me with this? What I must do to work in the same form with multiple user?


    Regards

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,387
    already have put the two files: back-end and front-end on the network server
    unless it has changed for 2013, each user should run a copy of the front end located on their machine

  3. #3
    Vandacardoso is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    29
    Yes they run. But the problem is that only 1 can work on a Form, the other can't work on the same Form. Do I have to give some instruction on the database?

  4. #4
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,387
    not clear what you mean

    I suggested each user should have a copy of the front end on their machine and you responded 'yes they run'

    and what do you mean by 'work on a form'? entering/viewing data?

    If every user has their own copy of the front end and share the back end, multiple users can work at the same time - but not in the same record

  5. #5
    Vandacardoso is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    29
    Ok. Each User have a copy of the front-end on their machine. So far so good! Problem: User 1 open the front-end file on is machine and if is the only user with the front-end file opened he can entering data. But if the User 2 open's the front-end file on is machine the User 1 lost is capability to entering data. The same goes to entenring new records. None of the User can make new record.

  6. #6
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,387
    In that case I suspect there is something wrong with the recordsource to your form - perhaps it includes a lookup record of some sort which is causing it to be locked.

    I presume your backend is an accdb?

  7. #7
    Vandacardoso is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    29
    Yes my back-end is accdb.
    Is it possible that the automatic numbering is the problem?

  8. #8
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,387
    I wouldn't have thought so. Regret I don't use 2013 so can only guess at the problem

    Do you have any code/macro's that lock the database?

    What is the recordsource to your form?

    Does your recordsource tables use lookups or multivalue fields?

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    I have multi-user split db and multi-user non-split db (I know, not great idea but it's what they wanted and it's been working for 4 years). Never encountered this issue with either.

    I NEVER set lookups in tables or use multi-value fields.

    Another recent thread had similar issue. They eliminated multi-value field and the issue went away.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    Vandacardoso is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    29
    No I don't have macros to lock the database. I make a test in my network with a simple database, only with 1 table with a record and the problem still the same. It is possible that the problem is with the network?

  11. #11
    Vandacardoso is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    29
    But I can't eliminate multi-value fields in my database, I need them ;-).

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    Why? Can use a related table. That was the solution other poster went to.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  13. #13
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,715
    You do NOT need to use multivalued fields.
    Set up a proper table as June suggested.
    Multivalued field is a recent M$oft Access only "feature" that most developers avoid.

    You can modify your table structures to achieve proper data storage.

  14. #14
    Vandacardoso is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    May 2015
    Posts
    29
    I think the problem is no more on that. I think is a network problem, but only tomorrow I can test the network. Thank for Your help!

    June7, how did You make Your database to work as multi-user? What are the steps?

  15. #15
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    Ideally, a multi-user db is split. Tables in backend located on network server. Everything else in frontend that links to backend tables. Copy of frontend on each user computer.

    For the non-split db, I did nothing special - just put the file in a shared folder on the network. Anyone with permission to that folder can open it. We tested multiple users opening the same file and entering data. Data is saved. So far the file hasn't crashed and never lost data, keeping fingers crossed. It is a very small db with absolutely no code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database with Multiple USers
    By stryder09 in forum Access
    Replies: 5
    Last Post: 09-09-2014, 01:07 PM
  2. Using multiple users for a database
    By bigern87 in forum Access
    Replies: 3
    Last Post: 07-03-2012, 02:01 PM
  3. new database with multiple users
    By Inter-Tech Communications in forum Database Design
    Replies: 1
    Last Post: 04-19-2012, 04:43 PM
  4. Multiple users in database at same time
    By toshea in forum Security
    Replies: 4
    Last Post: 12-07-2009, 02:22 PM
  5. Multiple users accessing same database
    By 4ACE in forum Access
    Replies: 0
    Last Post: 02-28-2008, 03:10 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