Question How to open Ms access 2010 database in ms access 2007

[javafun]

i am quite new to Ms access, i made a small application in ms access 2010.

1- my Colleague who has 2007 can not open it,"Unrecognized database format"
2- in the assign activities codes form, can you please suggest more elegant solution, crosstab will be perfect in this case but unfortunately it can not be updated.
3- in Graphic report form, how to delete the second combobox selection, when i change the first selection.


thanks very much

 

[javafun]

1. You can only open an A2010 database with A2007 if it has no A2010 objects. Unfortunately, even trying and then deleting one will make the database not backwards compatable. You could try to create a new empty database and then import all the non-A2010 objects.
2. In some cases, you can make multiple subforms and organize them in a way that looks like a grid but the only option you have with a grid-like format is an unbound form. It is better to train the users to do their data entry with a normalized form and do their viewing with crosstabs. When my customers ask for Excel-Like data entry forms, I tell them that a normalized form will cost $1 and a grid-like form will cost $50+ depending on how complicated it actualy is. They're usually happy as long as they have an Excel-like report.
3. In the AfterUpdate event of the first combo set a null value to the second combo.
Me.SecondCombo.Requery
Me.SecondCombo = Null

thank you very much

 

[aahmn]

I was having this same problem for a while, and figured out that they were Access 2010 encryption issues. There were no problems with my actual database. To fix it, I had to open a new 2010 database and import all my objects, and save. Then it opened in 2007 just fine. Unfortunately, this became a constant issue as I added forms and worked on my database, so I ended up just having 2010 removed and working in 2007 to avoid the conflicts.

 

[fedydavis]

There are some features that are not applicable in Access 2007. In order to make Access 2010 compatible with Access 2007, you should create a new database with the help of Access 2010 and make sure that you have selected Blank Database, then clock on External Data tab, and then select Access from the ribbon. And then you can import the entire objects from previous database into the new one. And then save the database newly created. Now you can access 2007 easily. For more information, visit: sites.google.com/site/accessrepairrecovery

 

[gemma-the-husky]

you need to develop in the lowest version of access your users will have.

in this case, either develop in A2007, or get the A2007 user to upgrade to a later version

He could use the free runtime edition, although he would then lose all the inbuilt menus.