used a 2007 database on Vista x64 platform

[sportsguy]

now the database format is unrecognized by XP access 2007. . .

any suggestions or totally corrupted?

have not had this problem going between OS platforms before.

thanks in advance

sportsguy

 

[GinaWhipp]

Not sure I understand, an .ACCDB will never be recognized by anything below Access 2007. It has nothing to do with the Operating System. OR are you saying it's an .MDB?

 

[sportsguy]

original database was XP created Access 2007.accdb
I used the *.accdb database on a Vista x64 machine,
now the same *.accdb database is in an unrecognized format by XP. . .

Its not supposed to happen doesn't help! and i have switched platforms several times with no issues. . .

any suggestions?

thanks in advance

sportsguy

 

[GinaWhipp]

As I said an .ACCDB cannot be opened in Access XP or anything lower then Access 2007. It has nothing to do with the Operating System, it is Access. Access .MDB's can be opened in any version but not .ACCDB's. You would need to convert it back to an .MDB, stripping any of the new features you used first, to open in Access XP.

Note, this is becase .ACCDB is an entriely different format then an .MDB and is not backwards compatiable.

 

[sportsguy]

Why do I need to back to *mdb?? Both systems are Access 2007 *.accdb,
and the database was created in Access 2007 *accdb.

what does *.mdb have to do with anything?

I don't understand, you are asking me to rename the database *.mdb to be able to be opened by Access 2007? even though *.mdb was never used and Access 2007 was only used?

 

[sportsguy]

Don't confuse Access XP (2002) with the operating system.

The only difference is that I used the database on a Vista x64 system, and then back on an XP OS system. I realize that the OS should not matter, but that is the only difference when I saved the database

thanks

 

[GinaWhipp]

My mistake I THOUGHT when you said XP you were referring to Access and not Windows. Then no it should make no difference. However, I would then check the References. Sounds like it might be getting *stuck* when moved over to the 64 bit machine. To open the one that won't open, hold down the Shift Key and go directly to the VBA Editor to get to Tools > ZReferences.

 

[sportsguy]

Its "stuck" back on the XP OS system, I agree with the fact that XP is opening a database with a higher level reference, but I have never had "unrecognized format" before. I hd just done an UPDATE on the Vista x64 system, and there were OFFICE updates, so potentially, a recent 2007 OFFICE update in X64 land could have caused an issue.

Holding the shift key down doesn't help. . .I can't import from the database either.

Just glad that it wasn't a primary database.

i am going with its corrupted! hopefully, its not my disk drive, and so its off to buy a new disk after 3 years.

 

[GinaWhipp]

I'm going with that also as everything has been tried... I would make a copy of another database and try it and see what happens before blaming it on the hard drive.