Access 2000 file is now Access 97 file??

[Cheekie]

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

[MMcCarthy]

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

[ADezii]

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!

[MMcCarthy]

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

[ADezii]

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!

[NeoPa]

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.

[MMcCarthy]

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.

[NeoPa]

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.