Results 1 to 15 of 15
  1. #1
    mismag is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Location
    California, US
    Posts
    58

    Multiple users single form to enter data

    Hi,

    With the help of this forum members, I was able to create a database for our car dealership data.
    I have stored the database in a shared location.
    Now I need to give access to another user, so we both can enter data simultaneously into the database.
    I have split the database into front end and back end.
    The default open mode is set to Shared.

    Still the other user is not able to open the forms or queries that I created.

    Any help is greatly appreciated.

    Thanks,


    Mismag

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Do each of you have a separate copy of the front end on your computers? If not you should.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    mismag is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Location
    California, US
    Posts
    58
    Yes, we have a separate copy of the front end.
    Yet it gives the following error message.
    Attached Thumbnails Attached Thumbnails Error.JPG  

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Where is the back end? It appears the user doesn't have access to it. Or you've used a mapped drive on your computer that they don't have.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    mismag is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Location
    California, US
    Posts
    58
    Both the database front end and back end are in One drive shared location where we all save our excel reports.
    G Money - Documents is a folder in One drive.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I don't think anybody has had success putting a back end in One Drive/Dropbox/whatever. If I'm wrong hopefully they'll chime in with the fix.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    mismag is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Location
    California, US
    Posts
    58
    If I don't save the back end in shared location, how will the other user's data be stored in the back end tables?

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Typically it's on server on a network where the PCs are also on the network. It could be on a networked PC that's accessible to the other user(s) as well. It's the cloud shared location that is a problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  9. #9
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Using this db over a web based connection is just asking for trouble. I'd rather risk sharing an unsplit db over a network before I'd connect one to a back end on One Drive. Such drives are for storage, not for actively writing to like a db does. Heck, I might even use a thumb drive over the OP's method - and I basically wouldn't want to do either of the latter with my own db.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  10. #10
    mismag is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Location
    California, US
    Posts
    58
    Micron,

    Quote Originally Posted by Micron View Post
    Using this db over a web based connection is just asking for trouble. I'd rather risk sharing an unsplit db over a network before I'd connect one to a back end on One Drive. Such drives are for storage, not for actively writing to like a db does. Heck, I might even use a thumb drive over the OP's method - and I basically wouldn't want to do either of the latter with my own db.
    What would be a better solution?
    I need to be able to share the database, so both me and my colleague be able to enter data simultaneously.

    Thanks,
    Mismag

  11. #11
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    See post 8.

  12. #12
    Join Date
    Apr 2017
    Posts
    1,673
    Quote Originally Posted by pbaldy View Post
    Typically it's on server on a network where the PCs are also on the network. It could be on a networked PC that's accessible to the other user(s) as well. It's the cloud shared location that is a problem.
    I think this will not be the problem when the server is in cloud (you can rent web-based 'terminal server') , back-end is on shared resource on this server, and all front-ends are also on same server in different user profiles, and Access is installed on server. And users connect to their profiles over VPN.
    At least theoretically it would work. Haven't tried this though - all users for my apps are in corporative LAN.

  13. #13
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Quote Originally Posted by ArviLaanemets View Post
    I think this will not be the problem...Haven't tried this though
    Thanks for chiming in. I have tried it, and while it may work performance can be a major problem. The app has to be designed to really minimize the data that crosses the wire. More:

    http://www.kallal.ca/Wan/Wans.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  14. #14
    Join Date
    Apr 2017
    Posts
    1,673
    I have tried it, and while it may work performance can be a major problem
    In case both front-and back-end are on same remote resource, it my be some problem, but definitely not a major one. Data is moved on same server - only keystrokes and screen images are moved over WAN. And somewhat slower performance is better than no performance at all

    Printing reports may be a real problem with this setup though. Maybe OP has to install some PDF printer (e.g. CutePdf which is quite good, and free) on server, to print reports to pdf-files, to load them down, and print then out locally!?

  15. #15
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I missed where you mentioned the front ends being on the same server as the back end.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 11-21-2013, 10:28 AM
  2. Replies: 3
    Last Post: 11-19-2013, 11:30 AM
  3. Replies: 5
    Last Post: 08-20-2013, 09:37 AM
  4. Replies: 5
    Last Post: 05-13-2013, 09:18 PM
  5. Replies: 7
    Last Post: 11-21-2012, 01:41 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