 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2005Disaster has struck
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. > Hi everyone! First post, so please bear with me! Thanks in advance for your > help. [quoted text clipped - 16 lines] > > Please help, I'm almost at my wits' end!! 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?  SignatureRegards Alex White MCDBA MCSE http://www.intralan.co.uk > Hi everyone! First post, so please bear with me! Thanks in advance for > your [quoted text clipped - 20 lines] > > Please help, I'm almost at my wits' end!! 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 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. > [Continuation of previous message] > [quoted text clipped - 6 lines] > times, and then it says that the function in 'Date' in undefined. This, > along with everything else, worked perfectly an hour ago. 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. > 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? Hi Ellie, See See http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html for information on the "references" problem. >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? -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. 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 >You, sir, are a genius. No way. All I do is remember how to find Doug's article. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.