Results 1 to 4 of 4
  1. #1
    jojowhite's Avatar
    jojowhite is offline Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    434

    help creating multi-user db

    i have an inventory database and i want it to share it with my co-workers to update the records
    and at the same time enter new records to the database.



    what are the steps i need to to accomplish this task?

    thanks in advance for those who will answer.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,566
    Quote Originally Posted by jojowhite View Post
    i have an inventory database and i want it to share it with my co-workers to update the records
    and at the same time enter new records to the database.

    what are the steps i need to to accomplish this task?



    thanks in advance for those who will answer.
    Split the dB and give each user their own copy of the FE. DO NOT share the FE.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    jojowhite's Avatar
    jojowhite is offline Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    434
    What is an FE? why can't I share it?

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,566
    Quote Originally Posted by jojowhite View Post
    What is an FE? why can't I share it?
    FE - Front End - forms and reports
    BE - Back End - Data

    Sharing an FE will eventually lead to corruption.

    Your call.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 2
    Last Post: 01-11-2022, 03:09 AM
  2. Replies: 8
    Last Post: 01-29-2019, 07:51 PM
  3. Creating database for Multi User
    By zahin in forum Database Design
    Replies: 3
    Last Post: 07-05-2014, 11:21 AM
  4. Replies: 2
    Last Post: 01-26-2013, 11:38 PM
  5. Replies: 3
    Last Post: 09-22-2011, 03:35 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