Results 1 to 8 of 8
  1. #1
    LLf060787 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    3

    Split database that won't allow multiple users

    I recently split a database I created a year ago - Got a accdb file and a accde file. This database has multiple forms where thru a search option the form is populated with data from a Main Table that's housed in the back end. The user then enters additional data to the sub form and thru macros both sections are appended to other tables. I've made copies of the front end (Named each front end differently)for the 4 users that are going to be entering data. The issue I'm having is that the first person in their front end is ok and can get to work. The 2nd and additional others will open their front end and the form is already populated and stuck with the data that's in the very first row of the Main Table. I've tried everything. I've even made multiple copies of the Main Table in the back end, named them differently and then linked one to each of the front ends under the "Main Table" name so that they're not all drawing data from the same table. Nothing works. What am I doing wrong. FYI - I'm not much on VB codes.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Can you post a copy of the front and back end as .accdb files
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    LLf060787 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    3
    This database contains employee data. I would not be able to post the full front and back ends without masking the data first

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by LLf060787 View Post
    This database contains employee data. I would not be able to post the full front and back ends without masking the data first
    That's fine. Just include a few dummy records.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Make sure you're not allowing the back end to be opened exclusively, and you probably should set the record locks option to 'none'.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by LLf060787 View Post
    This database contains employee data. I would not be able to post the full front and back ends without masking the data first
    Moke123 wrote some code to randomize the data.?
    I haven't had to use it, but you might find it useful?
    Attached Files Attached Files
    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

  7. #7
    LLf060787 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    3
    Where can I check to see If I'm allowing the back end to open exclusively?

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Where can I check to see If I'm allowing the back end to open exclusively?
    Options>Client Settings>Advanced - Default Open mode
    It is also possible using the /excl switch but I believe you'd have to be using a desktop shortcut. If you are opening the db that way, check the end of the shortcut for those characters.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Distributing Split database application to different users
    By hemantsogani in forum Database Design
    Replies: 6
    Last Post: 08-17-2020, 12:48 AM
  2. Multi Users on backend of split database
    By Tammy in forum Database Design
    Replies: 10
    Last Post: 12-16-2014, 01:56 PM
  3. Users cant use split database simultaneously
    By alexandervj in forum Access
    Replies: 12
    Last Post: 02-28-2014, 03:18 PM
  4. Replies: 62
    Last Post: 01-28-2014, 06:24 PM
  5. Multi users and Split Database
    By cohrsman in forum Access
    Replies: 4
    Last Post: 08-01-2013, 09:13 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
  •  
Other Forums: Microsoft Office Forums