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