Disaster has struck

  • Thread starter Thread starter Ellie via AccessMonster.com
  • Start date Start date
E

Ellie via AccessMonster.com

Hi everyone! First post, so please bear with me! Thanks in advance for your
help.

I have been creating a database in Access 2000, and had just completed the
finishing touches. I sorted out the startup options, so that screen X was
displayed when the database was opened etc, and everything was working fine.

All of a sudden I am getting "This database is in an unrecognized format"
errors. "The database may have been created witha later version of MS
Access than the one you are using. Upgrade your version of MS Access to the
current one, then open this database."
BUT I have been using the same version of Access right from the word go,
and I have not upgraded it, nor converted the database from an older
version. This error just came up out of the blue, and is even affecting
old, redundant versions of the same database I haven't touched for weeks.
It won't let me edit or even open the database, and I am in serious trouble.

This project has to be fully completed and documented for MONDAY.

Please help, I'm almost at my wits' end!!
 
Do you have an earlier version of Access installed in your computer?
It could be that in your windows it defined that when trying to open an mdb
file, then open it with a certain mdb.
in that case you can do three things
1. open Access first and then open the mdb
2. create a short cut in the computer where you define which Access to open
and then the name of the db
3. chane in your windows to run Access 2000 when trying to open mdb files.

I hope that was the case.
 
Have you tried a compact and repair, by opening access first and then trying
compact and repair. No database open just access goto Tools/Database
Utilities/Compact and Repair?

If that does not work, try this create a new database and try and import all
the objects from your old one. You will have to set thing like your startup
form, autoexec macro (if you are using them).

Are you able to just get into Access on it's own?

It is possible that you may have to reinstall Access if this problem is
happening with all your databases.

Has anything changed on your PC since the last time it worked?
 
Many thanks for replying so soon!

I only have Access 2000 on my computer, and have never had any other
versions. The odd thing is, that it was working fine one minute and not
workaing at all the next. No apparent change inbetween.

"Have you tried a compact and repair, by opening access first and then
trying compact and repair. No database open just access goto Tools/Database
Utilities/Compact and Repair?"
I have just had at, and whilst the file size has decreased, I'm still
getting the same problems.

I can open Access by itself no problem, and I can open databases that
aren't connected to this project, but anything that is to do with it (and
is also recent) is misbehaving to one extent or another.
 
[Continuation of previous message]

Apologies for the typos in the message above - I'm typing a bit too
hurriedly!

With regards to the 'odd errors' I mentioned... simple things...
For instance, trying to open a simple query whose only criteria is < =Date()
in a date field, I have to suffer the "unrecognized format" error 8
Click to expand...
times, and then it says that the function in 'Date' in undefined. This,
along with everything else, worked perfectly an hour ago.
 
That use to happen to me when one of the reference files where missing, check
the reference, see if anything missing, and check if you have reference to
Access object library, file called MSACC.OLB.
To open the reference open on of your module, or the immidiate window, go to
tools reference.


Ellie via AccessMonster.com said:
[Continuation of previous message]

Apologies for the typos in the message above - I'm typing a bit too
hurriedly!

With regards to the 'odd errors' I mentioned... simple things...
For instance, trying to open a simple query whose only criteria is < =Date()
in a date field, I have to suffer the "unrecognized format" error 8
Click to expand...
times, and then it says that the function in 'Date' in undefined. This,
along with everything else, worked perfectly an hour ago.
Click to expand...
 
Thanks Ofer, just given that a shot and something rather interesting has
come up...

On the REFERENCES list, "bp2002.mde" is marked as missing. Should this be a
problem, since I'm using Access 2000?
 
If you have a reference to another mde, you might using some function from
that mde, try and compile the main mdb, if you get error message of
unrecognise function it meen that you either return that mde or remove it
from the reference.

if you dont need it then remove it
if you use it then put the mde where it need to be.
 
Big big thanks to all of you - problem solved!

John, unselecting that missing reference in MS VB eventually allowed the
whole thing to work again. You, sir, are a genius.

Thanks again,
Ellie
 
Back
Top