Can someone open my attachment using Access 2003?

[Big Pat]

Hi,


I posted a question the other day http://www.access-programmers.co.uk/forums/showthread.php?t=143027 about not being able to open an Access 2003 database in Access 2007. It was asking for a password when I hadn't set one.

I gave up on that, started from scratch at home on Access 2007 last night and then saved the database in Access 2003 format. Took it to work on my USB drive today - where we use Access 2003 SP3 - tried to open it and had a message pop up saying that the database was an unrecognised format, or words to that effect. This is bugging the heck outta me!

I'm really beginning to suspect there is a problem with Access at work. Our IT guy downloaded the hotfix suggested by Moniker, but I can't see if it made any difference.

I've taken a fresh copy of my A2007 database, saved it in A2003 format again and attached it as zipped file below. Can someone just please see if it opens properly on their PC? It's very rough and ready as I only spent about an hour on it last night, but I just need someone to tell me if they can see the tables, forms etc.

- If you CAN open it, then I've got some evidence that there's a problem at work and can maybe talk our IT dept into a reinstall (or a new PC)

- If you CAN'T open it, then I must be doing somethnig wrong here and I'd really appreciate further advice.

Thank you very much for your help.

 

[Mike375]

I can open with Access 2003. Can see tables/queries/forms and can open them.

 

[Big Pat]

Thanks Mike. That's what I suspected and I feel vindicated. I'm not going mad after all )

Anyone else?

 

[jdraw]

Thanks Mike. That's what I suspected and I feel vindicated. I'm not going mad after all )

Anyone else?

Quite often, if you have multiple versions of Access on your machine, Access will try to use whatever version you last used. That is if you were last using Access 2000, and try to open an Access 2003 database, you could get the unrecognized format error. When this happens to me ( I use 97, 2000 and 2003). I go back and select the version I want to open.

 

[Sum Guy]

This is a problem with a lot of Microsoft Office software.
As a rule, an old application can configure itself to a newer version without much difficulty.
This is NOT true going the other way.
In the past I have had no difficulty making an Access 97 database into an Access 03 database. Making an Access 03 database into an Access 97 rarely works at all.
I have yet to try Access 07. I believe I'll wait until at least 6 months go by with no postings such as this.

 

[boblarson]

Also, something to note for Vista users:

If you use Windows VISTA, you must set each version's MSAccess.exe file to run as administrator or it won't be able to make the appropriate registry settings for it to run correctly.

See here how to do that:
http://www.btabdevelopment.com/main...ista/RunasAdministrator/tabid/87/Default.aspx

 

[Big Pat]

Quite often, if you have multiple versions of Access on your machine, Access will try to use whatever version you last used.

Thanks, but this isn't about multiple versions on one machine. It's Access 2003 at work and Access 2007 at home. Each PC has just one version.

As a rule, an old application can configure itself to a newer version without much difficulty.
This is NOT true going the other way.

That may be why converting from A2007 back to A2003 was unsuccessful, but doesn't explain why the original A2003 version that I brought home from the office would not work on my A2007 machine.

Did you each manage to open the attachment though?