Results 1 to 7 of 7
  1. #1
    Glenn_Suggs is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    72

    Multi-user application

    Hello all... Does anyone know how I might set up an application in Access so that multiple users can run it at the same time on a network? The problem is that there is an extract when the app opens that creates a table to be used later on and if more than one person opens the app at the same time, it causes issues. Both users can't write data to the same table at the same time through a make-table query. Is there a solution to this like a setting that will tell Access to wait if one user has the file already open when another is trying to work with it? Any help in this area would be greatly appreciated.


    Glenn

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you dont need that table.
    but you MUST split the database:
    1. put the unsplit db on the network where all can use it.
    2. split the db. front end (FE) has the forms,queries, etc, and the backend (BE) tables only.
    3. remove the FE from that folder and deliver it (email) to all users. Each user can run it on their desktop.

    you get the error because 2 people cannot use the same form....so now everyone has their own.
    continue to update a master copy, then when ready, again deliver a copy to all users evertime you update the FE.

  3. #3
    Glenn_Suggs is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    72
    Thanks for your reply. The table you said I don't need is an attempt to get the data entirely into Access instead of querying a bunch of huge Oracle tables every time someone needs to get to the data. Again, thanks.

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You could have a table that contains start time and end time. If the start date is today then do not run the query, if it is not today, then update the startdate to Now() and the endtime to null and run the query. When the second user opens the database the query will not run. You can optionally tell the second user that the query is still running if the enddate is null and to wait until it is finished.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See this info from FMS re multiuser Access
    Also, can you clarify why users get data from Oracle then write to the downloaded data.
    Perhaps a more complete description of what you are doing in business terms would be helpful.

  6. #6
    Glenn_Suggs is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    72
    Quote Originally Posted by orange View Post
    See this info from FMS re multiuser Access
    Also, can you clarify why users get data from Oracle then write to the downloaded data.
    Perhaps a more complete description of what you are doing in business terms would be helpful.
    The short answer is that the users enter information into the Oracle database about jobs that are to be done. That is the same data that is extracted into Access and information is added to it to be stored on a local server. I know the question at this point is probably why not add the new data to Oracle. If our department had control in that area I'm sure we would do it that way.

  7. #7
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    If your department has a business need, and
    that need involves the process that inputs data into Oracle, and
    the data in Oracle is insufficient to meet your needs, then
    someone should identify and analyze the issue in business terms.
    If the need is impacting business, a manager/decision maker should be made aware so they can act on it.
    If it is considered an inconvenience and not a severe enough business problem, then carry on. At least you have brought the matter to management.

    The questions I have:
    Why are you putting data into Oracle and then downloading it and adding to it?
    Who uses the data that you enter into Oracle?
    Could/Would they benefit from your additional data?
    When was the last time the processes involved were reviewed?

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

Similar Threads

  1. Multi-user Front End application
    By emanual4real in forum Access
    Replies: 2
    Last Post: 02-24-2014, 10:44 PM
  2. Replies: 2
    Last Post: 08-31-2012, 02:20 PM
  3. Including a user guide within an application
    By PippaPippa in forum Forms
    Replies: 7
    Last Post: 03-10-2012, 04:36 AM
  4. Replies: 3
    Last Post: 09-22-2011, 03:35 PM
  5. Creating a Clean User Application
    By sesproul in forum Forms
    Replies: 1
    Last Post: 03-05-2010, 06:32 PM

Tags for this Thread

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