Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Access database limits

Status
Not open for further replies.
jamsek19

jamsek19

Programmer
Feb 4, 2002
35
SI
Hello.
Does anybody know the limits of MS Access 2000 database: max tables defined, max fields per tables, max size of table, max size of database, max connections opened simultaniously, ...
A link of these values also make me happy.

Thanks Andrej
 
Sort by date Sort by votes
you can check in access help under access specifications.
For example max fields in a table :255 fields
32768 objects in a database,db max size 2GB etc...

But be carefull, all those limits a not really practicable !
For exemple 255 concurrent users .... I have problems to get 15 people working ...


 
Upvote 0 Downvote
Thanks for fast info.
Just about concurrent users: are they really accessed DB at the same time or they're just connected to database and access to DB was periodical?
Thanks
Andrej
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
1K
strongm
strongm
sal21
  • Locked
  • Question
via vb 6.0, please split access table
Replies
1
Views
294
strongm
strongm
sal21
  • Locked
  • Question
SORT DATE in msflexgrid not correct
Replies
4
Views
283
sal21
sal21
sal21
  • Locked
  • Question
CREATE msflexgrid as in xlsx file 2
Replies
8
Views
499
strongm
strongm
sal21
  • Locked
  • Question
WHY the sort dont work in msflexgrid
Replies
1
Views
204
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top