MS Access Multiuser - Access 2000 limitation?

Author

Access 2000 limitation?

mikea

2006-03-15, 1:25 pm

I am wondering if access 2000 has a table size limitation. A limit to the
number of entry's perhaps or something similar. Reason being is that i have
a department of users that state that they need office 2003 because access
2000 'could not handle all of the data being input'. I am aware of access
having a limitation - in terms of practical usage - when the number of
simultaneous users reaches above about 10. But i have not heard of access
2000 having a limitation of the sort previously mentioned. Is there a limit
like this, or a macro limit, or forms limit or something else like this
inherant to the application and not being machine specific(this dept is only
about 10 people and if this app was to be multiused that would be the
greatest utilization at one time and they are using top of the line Hp
workstations). Thanks

Steve Schapel

2006-03-15, 8:25 pm

Mikea,

There are, of course, specifications relating to Access. For example 2
Gb maximum file size. As far as I am aware, these specifications did
not change significantly between Access 2000 and Access 2003. Are the
users of the Access 2000 application experiencing a specific problem?
If so, I think identifying the problem is the first step, i.e. what
really is the meaning of "could not handle all of the data being input".
Whatever the meaning, it is very unlikely that moving to Access 2003
will, in itself, solve it.

By the way, a well designed Access application should be able to support
a lot more than 10 users.

--
Steve Schapel, Microsoft Access MVP

mikea wrote:
> I am wondering if access 2000 has a table size limitation. A limit to the
> number of entry's perhaps or something similar. Reason being is that i have
> a department of users that state that they need office 2003 because access
> 2000 'could not handle all of the data being input'. I am aware of access
> having a limitation - in terms of practical usage - when the number of
> simultaneous users reaches above about 10. But i have not heard of access
> 2000 having a limitation of the sort previously mentioned. Is there a limit
> like this, or a macro limit, or forms limit or something else like this
> inherant to the application and not being machine specific(this dept is only
> about 10 people and if this app was to be multiused that would be the
> greatest utilization at one time and they are using top of the line Hp
> workstations). Thanks

Albert D.Kallal

2006-03-15, 8:25 pm

Not that I know of. The limitations are the same.

In terms of capacity, access 2000, and a2003 are the same. In fact, access
2003 DEFAULTS to a2000 file format.

likely, those a2003 users are working with a2000 format files. MS did this
on purpose, so a2000, a2002, and a2003 could work on the same datafiles....

So, there is some code differences, but in terms of data, and capacity..they
are the same...

However, if you need access2000, access2002, and access 2003 ALL WORKING on
the data at the SAME TIME in a multi-user setup, you can also do this. You
could even get ms-access 97 to work here also, if you needed. So, you can
actually have 4 versions of ms-access with all the users EDITING the data at
the SAME time...

The approach and solution is outlined here

http://www.members.shaw.ca/AlbertKa...split/index.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@
msn.com
http://www.members.shaw.ca/AlbertKallal

Sponsored Links