Member Avatar for dilip_singh3

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.

  • 2 Contributors
  • 1 Reply
  • 142 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by QVeen72
Member Avatar for QVeen72

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.