Question Opening a 2007 DB in 2003 a mess?

[UnrealEnvy]

Hello everyone!
I'm new to Access programming, and have a question that would help me a lot.
I've created a DB in Access 2007, which works just fine.
I've saved the DB as MDB to be 2003 compatible, and sent it to my friend, who needs it.
He is using Access 2003, but he can't work with the DB because:
1. Instead of the button icons, he sees "command" written.
2. 2 of the subforms are showing all the date without a scrollbar.
3. When he clicks on a field in a subform, he gets an error.

I already compiled and repaired the Db.
What's wrong, and how can I fix it?
I'd appreciate any help!
Thanks in advance,

Tal.

 

[HiTechCoach]

Even thought you can create things in 2007, Access 2003 will not understand them. Like embedded macro do not downgrade properly. Command buttons with images do not downgrade.

You have to not use any of the new features available in 2007 if you w3ant it to be backwardly compatible.

I find it best to start the database in 2000 format and keep in that format if you eve want to use it with an earlier version. You will still have some issues, but there will be less of them.

I would recommend that you have them download the free Access 2007 runtime and use it to open your database.

 

[UnrealEnvy]

Thank you for the reply.
What you say makes a lot of sense, I guess that whenever I'll make DB's for other people, I will be sure to check what Office version they are using before starting work on it.

Thank you once again, for both the answer and time.

Tal.