How many tables we can create in a single MS Access database ?
I m going for a multiuser project .
I dont know how many tables I will have to make.
dilip_singh3
0
Newbie Poster
QVeen72
104
Posting Shark
Hi,
Max Number of OpenTables is 2054.
More than that, you shud be aware of few more realities with Access:
Practically, After 10 Concurrent users , Access Slows Down/Does Not Accept New Connections/Throws errors..
Max Limit of Access is 2gb, which is easy to hit for Multi-User large Applications..
Its OK for small applications, but for large applications, you have to go for robust RDBMS's
Regards
Veena
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.