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
|
|||
|
|||
# of users doing data entry?
Hi there,
Please excuse my silly question. I have an Access 2000 database on a shared network, with 12 users. I'm wondering if they can all enter and/or edit data - using forms - at the same time. Will it cause any problems? Thanks for your help! Tara |
#2
|
|||
|
|||
# of users doing data entry?
It depends.
Access specifications say that the maximum concurrent users is 255. That is the theoretical maximum. The practical maximum is much lower. 10-15 is usually noted as a reasonable maximum. But this can very depending on how intensive each user's usage is. If the multiple users are going to be editing the SAME record, you will have record locking problems, but that is true of any database, not just Access. Since Access 2000 and up has record-level locking, a user won't lock other records than his own if doing data entry. But if the users are doing update queries to the whole table, you may still get locking conflicts. With multiple users, the application should be "split" into a Front-End and Back-End, with the BE holding the tables and the FE holding everything else with the tables linked in. Also, for best performance, each user should have a copy of the FE on their workstation with the BE on the network. -- --Roger Carlson www.rogersaccesslibrary.com Reply to: Roger dot Carlson at Spectrum-Health dot Org "T" wrote in message ... Hi there, Please excuse my silly question. I have an Access 2000 database on a shared network, with 12 users. I'm wondering if they can all enter and/or edit data - using forms - at the same time. Will it cause any problems? Thanks for your help! Tara |
#3
|
|||
|
|||
# of users doing data entry?
Thank you so much for your help! Perfect solution. Thank
you again! -----Original Message----- It depends. Access specifications say that the maximum concurrent users is 255. That is the theoretical maximum. The practical maximum is much lower. 10-15 is usually noted as a reasonable maximum. But this can very depending on how intensive each user's usage is. If the multiple users are going to be editing the SAME record, you will have record locking problems, but that is true of any database, not just Access. Since Access 2000 and up has record-level locking, a user won't lock other records than his own if doing data entry. But if the users are doing update queries to the whole table, you may still get locking conflicts. With multiple users, the application should be "split" into a Front-End and Back-End, with the BE holding the tables and the FE holding everything else with the tables linked in. Also, for best performance, each user should have a copy of the FE on their workstation with the BE on the network. -- --Roger Carlson www.rogersaccesslibrary.com Reply to: Roger dot Carlson at Spectrum-Health dot Org "T" wrote in message ... Hi there, Please excuse my silly question. I have an Access 2000 database on a shared network, with 12 users. I'm wondering if they can all enter and/or edit data - using forms - at the same time. Will it cause any problems? Thanks for your help! Tara . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data entry forms and/or subforms | Hugh Crean | Using Forms | 2 | July 8th, 2004 05:56 PM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |
limit data entry to predetermined list | RagDyer | Worksheet Functions | 2 | October 29th, 2003 03:33 AM |
Excel Data Entry / Reference Question: Approach? | steve c matco | Worksheet Functions | 1 | September 29th, 2003 04:18 PM |