Limits to Tables

J

Jeff Boyce

Prurient interest or practical issue?

If former, check Access HELP on "specifications". If latter, please
describe more specifics.

More info, please...

Jeff Boyce
<Office/Access MVP>
 
B

bgarey

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?
 
K

KARL DEWEY

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.

Etc.
 
J

Jeff Boyce

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!

Regards

Jeff Boyce
<Office/Access MVP>
 
Top