Sounds very much like corruption & unfortunately compact & repair will have no effect on that. However all MAY not be lost.
Try each of these in turn ...
1. Do you have a backup that you can open?
2. Make at least 2 backup copies of your database for you to attempt repairs
3. Can you open the tables from another database?
4. Try DECOMPILING a copy of the database.
See
http://www.fmsinc.com/microsoftaccess/performance/decompile.asp
This is VERY quick and almost always fixes issues
If it opens successfully, RECOMPILE the code in the VBE and then compact
5. If it still fails, create a new blank database and import all database objects to that. That also won't take long
If it opens successfully, COMPILE the code in the VBE and then compact
If you now have a working database, bin the previous backups as they were 'duff'
Now make another new BACKUP of the working db
From now on, make regular backups
Check your database options - if Compact on Close is ticked, UNTICK it as that can cause corruption.
If still no good, there are a few more things to try .....