By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,516 Members | 1,369 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,516 IT Pros & Developers. It's quick & easy.

Access 2000 file is now Access 97 file??

P: 5
No one at my companies help desk can help me with this, so I thought I'd go to the experts =)

I have an Access 2000 file that I've been using Access 2003 to open. I have a laptop and a desktop at my station. When I opened up the database on my laptop it was fine. When I opened it up on my desktop, it shows as a Access 97 file, and now all my make table queries are gone. I called our Help Desk and after the knucklehead touched my laptop, I can't open it up on either system in the Access 2000 file. IS did a file restore and it's the same thing. Anyone have any idea what happened, or how I can fix it? I didn't create this database, someone else had, so I'm not sure how the make table queries were created or else I'd redo it.

Thanks
Mar 12 '07 #1
Share this Question
Share on Google+
7 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
It's hard to know without seeing the database.

You shouldn't really use an Access 2000 file in 2003 without converting it to current version. If the queries were made using code then the code may have become corrupted. Try opening a new 2003 database and importing all objects from the old corrupted file and see if that works. Remember to tick the options to import toolbars etc.

Mary
Mar 12 '07 #2

ADezii
Expert 5K+
P: 8,627
No one at my companies help desk can help me with this, so I thought I'd go to the experts =)

I have an Access 2000 file that I've been using Access 2003 to open. I have a laptop and a desktop at my station. When I opened up the database on my laptop it was fine. When I opened it up on my desktop, it shows as a Access 97 file, and now all my make table queries are gone. I called our Help Desk and after the knucklehead touched my laptop, I can't open it up on either system in the Access 2000 file. IS did a file restore and it's the same thing. Anyone have any idea what happened, or how I can fix it? I didn't create this database, someone else had, so I'm not sure how the make table queries were created or else I'd redo it.

Thanks
It seems to me that on your Desktop your Database was inadvertantly converted to Access 97 format with obvious loss in functionality. There should be no reason why the Access 97 Database cannot be re-opened in Access 2003 and converted back via the opening Convert/Open Dialog. You will not, obviously, regain the lost functionality due to the original conversion. As to what happened on the laptop, that can be any ones guess. I suggest talking to the Help Desk again and have them provide you with a detailed description of what procedures they performed on the laptop. I'm assuming that the Database on the laptop is still in the 2000 format even though you cannot open it. You can try to create a New Database in Access 2003 then Import all the Objects from the laptop version but there is no guarantee that this will work. Hopefully, there will be someone who can give you better insight into your problem than I. In any event, good luck in finding a solution. Sorry Mary, didn't mean to step on your toes with this one, your reply appeared out-of-the-clouds like someone from above!
Mar 12 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Sorry Mary, didn't mean to step on your toes with this one, your reply appeared out-of-the-clouds like someone from above!
I'll let you away with it since you've given a much more comprehensive answer. Just don't make a habit of it ;)

Mary
Mar 12 '07 #4

ADezii
Expert 5K+
P: 8,627
I'll let you away with it since you've given a much more comprehensive answer. Just don't make a habit of it ;)

Mary
I promise not to - next time I'll look up first!
Mar 13 '07 #5

NeoPa
Expert Mod 15k+
P: 31,441
No one at my companies help desk can help me with this, so I thought I'd go to the experts =)

I have an Access 2000 file that I've been using Access 2003 to open. I have a laptop and a desktop at my station. When I opened up the database on my laptop it was fine. When I opened it up on my desktop, it shows as a Access 97 file, and now all my make table queries are gone. I called our Help Desk and after the knucklehead touched my laptop, I can't open it up on either system in the Access 2000 file. IS did a file restore and it's the same thing. Anyone have any idea what happened, or how I can fix it? I didn't create this database, someone else had, so I'm not sure how the make table queries were created or else I'd redo it.

Thanks
This may seem like a silly question, but how do you determine what version of Access the database is in?
The reason I ask as it's easy to get confused by the icon showing against a file which simply indicates which is the default app associated with an MDB file and has no bearing whatsoever on the version of the files themselves.
Mar 13 '07 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
This may seem like a silly question, but how do you determine what version of Access the database is in?
The reason I ask as it's easy to get confused by the icon showing against a file which simply indicates which is the default app associated with an MDB file and has no bearing whatsoever on the version of the files themselves.
Open the application first and then open the file from the application. If it doesn't match Access will tell you.
Mar 13 '07 #7

NeoPa
Expert Mod 15k+
P: 31,441
This may seem like a silly question, but how do you determine what version of Access the database is in?
The reason I ask as it's easy to get confused by the icon showing against a file which simply indicates which is the default app associated with an MDB file and has no bearing whatsoever on the version of the files themselves.
Open the application first and then open the file from the application. If it doesn't match Access will tell you.
My question was of how the OP determined the situation rather than 'How does one determine which version...'
As long as that's clear, your explanation may well help anyway.
Mar 13 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.