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.


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


Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.