•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 456,578 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,617 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 1202 | Replies: 1 | Solved
 |
•
•
Join Date: Oct 2007
Posts: 24
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
Maximum no. of tables in MS Access Database ? 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.
I m going for a multiuser project .
I dont know how many tables I will have to make.
•
•
Join Date: Nov 2006
Posts: 743
Reputation:
Rep Power: 4
Solved Threads: 100
Master Poster
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
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
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Create Access Database using SQL queries (MS Access and FileMaker Pro)
- Create tables in access database by DAO liberary (Visual Basic 4 / 5 / 6)
- how to retrive data from different Ms Access tables using ASP (ASP)
- retrive data from different tables of Ms access (ASP)
- retrive data from different tables of Ms access (ASP)
- Linked SQL Server tables in MS Access (MS Access and FileMaker Pro)
- 10000 limit on Access 2000? (MS Access and FileMaker Pro)
- Connecting Access 2000 to a Sybase Database via ODBC (MS Access and FileMaker Pro)
- Accessing an Access Database using Java (Java)
- Create an Access Database using Java (Java)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: searching list of strings
- Next Thread: Connecting to sql
