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.

Re: Maximum no. of tables in MS Access Database ? 80 80


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 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.