A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

# of users doing data entry?



 
 
Thread Tools Display Modes
  #1  
Old August 13th, 2004, 03:47 PM
T
external usenet poster
 
Posts: n/a
Default # 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  
Old August 13th, 2004, 04:31 PM
Roger Carlson
external usenet poster
 
Posts: n/a
Default # 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  
Old August 13th, 2004, 06:05 PM
external usenet poster
 
Posts: n/a
Default # 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.