I believe that it limits to about 2,000 open tables and about 32,000
total objects (which includes tables, forms etc.)
There are other restrictions as well.
The question is why are you asking. It sounds like you may have a poor
database design if you need anywhere close to enough tables to be asking the
question.
Practical Issue:
I found the specifications, thanks.
The data base I am developing would need about 1600 tables for individual
students and their transcripts.
Is this practical?
Practical Issue:
I found the specifications, thanks.
The data base I am developing would need about 1600 tables for
individual students and their transcripts.
Is this practical?
Sound like a wrong database structure. It sounds like you want to have a
separate table for each student - wrong.
Have one table that list all students with another that list their
enrollment semesters. Third list their subject for the semester. Fourth
with the grades for the subject-semester.
As Joseph and Karl have pointed out, having 1600 tables would be a
remarkably complex design.
Consider posting back a description of what you are trying to do (not HOW).
If you have trouble getting started with a description, consider how you
would explain to an 80 year old grandmother what you were trying to do.
Hint: no technology!
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
