Why Can I Only have Five Records in A Table

[jammyo2k]

I'm using a query to add records to a number of tables. I am using a numeric field called 'Admission Number' as my primary key. My problem is that as soon as I have five records in each table any new records that I add replace the records already present.

Any help would be much appreciated.

Thank you

Jim

 

[llkhoutx]

Somethings happening that you don't see. You can and often do have millions of records.

I can't diagnose the problem from what you've posted.

 

[jfgambit]

Can you post a copy of you db to the site?

 

[jammyo2k]

I've uploaded a copy to the net. You should be able to view it here:

http://hometown.aol.co.uk/jammyo2k/jim026.zip

Its a 400K zip file.

Thanks for the help

 

[KevinM]

HOLY MOSES!!

Now that's what I call an 'un-normalised' database.

Haven't seen one like this since I had to re-design our old 'Exam Marking' database.




You don't need that many tables.

If it's a student/exam marking db then at the VERY least you need 4 tables...

1) Students
2) Subjects
3) SubjectsTaken
4) SubjectMarks

Have a look at restructuring your db with these tables and the correct relationships between them.

No offence or dis-respect but something as critical as students' marks should be handled in a much more professional manner by your admin dept and not just given to any member of staff to take on board.

 

[jammyo2k]

Its a school project and I'm nearly out of time. It's not a marking system as such, it's a system for monitoring the individual performance of students. As well as doing this it also has to provide statistical data and print out standard letters. Is there not a quick fix just to make it look like it works? I honestly don't have time to restructure it. I'm sorry to disregard your advice but I've seen databases with more tables (in fact this database is based on one of them) and they do not have this trouble.
Do you have any other suggstions?

 

[neileg]

Wow! KevinM is correct, it's a mess.

You can enter more than 5 students directly into the tables, the problem seems to lie in the Add Student query. I suspect its something to do with your relationships. Why are all the tables linked to the Art table? Shouldn't they be linked to the Student?

If you've modelled this on another database, you need to find new examples.

 

[jammyo2k]

Thank you, neileg, you were right. All I needed to do was change the Add Student query. Thanks for your help.
I know its a mess but I'm only an A-level student and a pretty bad one at that. My knowledge of Access is pretty poor as you can see by looking at the database. I'm not going to do IT at Degree level as you may have guessed.
Thank you