If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms w/ multiple users
I have a front end and back end database set up for multiple users. Each
user has a front end database and the tables are stored in the back end. However I'm having trouble. Two users can't access the form named "Input" at the same time. My users aren't really able to use the table and like the "form" set up. Any suggestions? |
#2
|
|||
|
|||
Why not? What error do they get? If they are each on their own copy of the
front-end, then I can't see how they would not be able to use the same form. It must be the underlying table or a record lock issue. How are your locks set up in the OPTIONS? Do you have record lock turned on? If so, does the form always try to open to the same record for each user? More details please. -- Rick B "Katie" wrote in message ... I have a front end and back end database set up for multiple users. Each user has a front end database and the tables are stored in the back end. However I'm having trouble. Two users can't access the form named "Input" at the same time. My users aren't really able to use the table and like the "form" set up. Any suggestions? |
#3
|
|||
|
|||
DOkay I have three users that use a database. The databases are stored on a
shared drive. The database for the front end is named FEFQC and the back end BEFQC. The users each have a link on desktop to FEFQC. There is a form in the database that ties to a table both are called "Input" They put most their information here in the form. The 2nd user has to go back to that form and add information, but they use a different computer. When that user tries to pull up the "Input" form they get error Could not lock table "Input" currently in use by User Admin on Machine ______. So they don't have their "own" copy since the 2nd user has to add information to the form. Options is set up as follows: Default open mode is set to: Shared Default record locking is set to : No Locks Open Databases using record-level locking is not checked. "Rick B" wrote: Why not? What error do they get? If they are each on their own copy of the front-end, then I can't see how they would not be able to use the same form. It must be the underlying table or a record lock issue. How are your locks set up in the OPTIONS? Do you have record lock turned on? If so, does the form always try to open to the same record for each user? More details please. -- Rick B "Katie" wrote in message ... I have a front end and back end database set up for multiple users. Each user has a front end database and the tables are stored in the back end. However I'm having trouble. Two users can't access the form named "Input" at the same time. My users aren't really able to use the table and like the "form" set up. Any suggestions? |
#4
|
|||
|
|||
Hum....
Ok, so, each user has a copy of the FE installed on each pc..right? You might want to check the settings for the actual form used..as each form also can have settings for locking data... Check the data tab of that form in desing mode and see what the record locks setting is -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#5
|
|||
|
|||
I know this sounds silly, but check to be sure the Input Form is actually in
the FE "Albert D. Kallal" wrote: Hum.... Ok, so, each user has a copy of the FE installed on each pc..right? You might want to check the settings for the actual form used..as each form also can have settings for locking data... Check the data tab of that form in desing mode and see what the record locks setting is -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#6
|
|||
|
|||
Well they don't have their own FE. The copy of FE is on the shared drive and
everyone uses the same one. That may be where my problem comes from. I just have one person that has to go back and add information to what the previous users put in. She I have her use the BE so she can access their information? "Albert D. Kallal" wrote: Hum.... Ok, so, each user has a copy of the FE installed on each pc..right? You might want to check the settings for the actual form used..as each form also can have settings for locking data... Check the data tab of that form in desing mode and see what the record locks setting is -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#7
|
|||
|
|||
Each user should have their own FE on their desktop. It creates multiple
problems and slows response when multiple users are sharing a FE on a shared drive. I would recommend putting the FE on everyone's desktop, then seeing if the problem still exists. "Katie" wrote: Well they don't have their own FE. The copy of FE is on the shared drive and everyone uses the same one. That may be where my problem comes from. I just have one person that has to go back and add information to what the previous users put in. She I have her use the BE so she can access their information? "Albert D. Kallal" wrote: Hum.... Ok, so, each user has a copy of the FE installed on each pc..right? You might want to check the settings for the actual form used..as each form also can have settings for locking data... Check the data tab of that form in desing mode and see what the record locks setting is -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#8
|
|||
|
|||
Ok. Here is a question - Basically there are 3 computer involved.
One computer is used by multiple people over three shifts to enter in data. The other is used by a person who goes in after them to enter in more information. I need the 2nd person to see the data the first group entered. Will that happen if there multiple FE databases. The third is my computer and I never enter data just run reports and I can use the BE for that. "Klatuu" wrote: Each user should have their own FE on their desktop. It creates multiple problems and slows response when multiple users are sharing a FE on a shared drive. I would recommend putting the FE on everyone's desktop, then seeing if the problem still exists. "Katie" wrote: Well they don't have their own FE. The copy of FE is on the shared drive and everyone uses the same one. That may be where my problem comes from. I just have one person that has to go back and add information to what the previous users put in. She I have her use the BE so she can access their information? "Albert D. Kallal" wrote: Hum.... Ok, so, each user has a copy of the FE installed on each pc..right? You might want to check the settings for the actual form used..as each form also can have settings for locking data... Check the data tab of that form in desing mode and see what the record locks setting is -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#9
|
|||
|
|||
Katie,
I am thinking you don't quite undestand the FE/BE model. If (as it should be) all the data is in the BE, then everyone using the FE will see all data entered in the BE. As to your using the BE for reports, that is incorrect. The correct implementation is only tables (data) should be in the BE. No queries, no forms, no reports, no nothing. Everything else should be in the FE. "Katie" wrote: Ok. Here is a question - Basically there are 3 computer involved. One computer is used by multiple people over three shifts to enter in data. The other is used by a person who goes in after them to enter in more information. I need the 2nd person to see the data the first group entered. Will that happen if there multiple FE databases. The third is my computer and I never enter data just run reports and I can use the BE for that. "Klatuu" wrote: Each user should have their own FE on their desktop. It creates multiple problems and slows response when multiple users are sharing a FE on a shared drive. I would recommend putting the FE on everyone's desktop, then seeing if the problem still exists. "Katie" wrote: Well they don't have their own FE. The copy of FE is on the shared drive and everyone uses the same one. That may be where my problem comes from. I just have one person that has to go back and add information to what the previous users put in. She I have her use the BE so she can access their information? "Albert D. Kallal" wrote: Hum.... Ok, so, each user has a copy of the FE installed on each pc..right? You might want to check the settings for the actual form used..as each form also can have settings for locking data... Check the data tab of that form in desing mode and see what the record locks setting is -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#10
|
|||
|
|||
You are correct. I really wasn't understanding how it worked. Thank you for
helping me understand it better. I'm going to try it out this afternoon and see if I can get it to work. Thanks Katie "Klatuu" wrote: Katie, I am thinking you don't quite undestand the FE/BE model. If (as it should be) all the data is in the BE, then everyone using the FE will see all data entered in the BE. As to your using the BE for reports, that is incorrect. The correct implementation is only tables (data) should be in the BE. No queries, no forms, no reports, no nothing. Everything else should be in the FE. "Katie" wrote: Ok. Here is a question - Basically there are 3 computer involved. One computer is used by multiple people over three shifts to enter in data. The other is used by a person who goes in after them to enter in more information. I need the 2nd person to see the data the first group entered. Will that happen if there multiple FE databases. The third is my computer and I never enter data just run reports and I can use the BE for that. "Klatuu" wrote: Each user should have their own FE on their desktop. It creates multiple problems and slows response when multiple users are sharing a FE on a shared drive. I would recommend putting the FE on everyone's desktop, then seeing if the problem still exists. "Katie" wrote: Well they don't have their own FE. The copy of FE is on the shared drive and everyone uses the same one. That may be where my problem comes from. I just have one person that has to go back and add information to what the previous users put in. She I have her use the BE so she can access their information? "Albert D. Kallal" wrote: Hum.... Ok, so, each user has a copy of the FE installed on each pc..right? You might want to check the settings for the actual form used..as each form also can have settings for locking data... Check the data tab of that form in desing mode and see what the record locks setting is -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
setup for multiple users | chevysales | Setup, Installing & Configuration | 1 | February 9th, 2005 04:22 PM |
Forms and multiple bumbering | Cor van der Bliek | General Discussion | 1 | February 1st, 2005 01:23 PM |
Multiple Calendars/Contact Lists (3) when adding another user's mailbox... | Confused | Installation & Setup | 4 | May 28th, 2004 02:56 PM |
Two versions again-language issue | Otto | Setup, Installing & Configuration | 3 | May 28th, 2004 04:57 AM |