Desperately need help with my database!

[dharmacloud]

I'm currently working on a student records database but have not been able to get all the parts working correctly. Would someone be able to take a look at my database and walk me through to solve a few of these critical issues to get it working? I can email you my database to review b/c I can't seem to be able to attach it to this post. I'm using Access 2007. I would really appreciate any help y'llcould give me.

[pbaldy]

Have you done a compact/repair and then zipped? That will make most files small enough to attach here.

[dharmacloud]

I tried compact/repair but it is not letting me b/c of my log on prompt. It keeps popping up even though I enter the correct username & password. The file is still a touch to big to upload 2.4mb. Can I email it to you and you can see if you can help me with it?

[pbaldy]

Sure:

removed to prevent spam

[pbaldy]

Here's your file and question so others can jump in.

I'm been working on this database but can't seem to get some of the pieces to work correctly. My main problem is trying to get the student courses queries to give the correct results. Currently it's not giving me the correct results. The SQL for the three union queries are incorrect but I don't know how to fix it. There's of course more but if can help me with that part first it would be most useful.


Log in user ID: jin jian
password: hello

[pbaldy]

You say the SQL is incorrect but don't say how/why. What is the result you're looking for from one of them?

[orange]

Further to Paul's comments, do you have your tables and relationships designed? Have you normalized your tables?
Can you tell us about "your business" --what is the database suppose to do/support?

Not everyone has Acc2007 or 2010 so can not open an accdb.
You may get a broader audience if you save a copy in mdb format.