MS access 2007 and popup menus

[clincoln]

I have run into the problem of MS seemingly dropping support for custom popup menus in Access 2007. My app heavily uses popup menus and suddenly I can not even change a typeo in a popup menu or add additional functionality.

Am I seeing this wrong or is there a way to change an existing popup menu in Access 2007?

Sheesh, first Vista, now this....... do I have ANY options here?

[NeoPa]

Personally I'm avoiding Office 2007 for as long as I can get away with it for, but check to make sure the database has been converted.

Access can usually run older databases (previous version formats) but will often only allow updating design for a current version database.

There is normally an option to convert. It is unlikely previous version clients will even be able to open it after conversion though. This can be a serious consideration unless you know only newer clients will ever be used.

[clincoln]

Yes the database has DEFINITELY been converted from 2003 to 2007 and the menu structures "changed". I tried to down-convert it back to 2003 but it totally changed the menu structure so that after down-convert I still con not get my menus back.

What is the industry doing to work around the issue.

One other question, if I can't update my popup menus I will have to resrite the application. I plan to change to another RAD tool other than Access. What viable options are out there?

[NeoPa]

From your comments I'm getting that you probably haven't kept a backup of the database from before it was converted. That's, well, unfortunate if true. It's always a good idea to take a backup before anything as fundamental as a version change. Otherwise a rewrite may well be your only option.

I think the industry is not as taken with Office 2007 as most of the user base. I may be wrong (I may just mix with people of like-mind of course), but I see very little to attract me to play with 2007. This is a non-issue for me. Google may well give you some different attitudes though.

As far as alternatives to Access goes, I'm not sure there are any. I expect there are some, but none that have the same level of support and pool of expertise. The only marginally helpful suggestion I could make would be to use Access 2003. Most people do, that have moved on from Access 2000 that is ;)

[clincoln]

Thanks NeoPa,

I do have a backup of the old 2003 database, but if I revert I will lose all of the programming changes made since the conversion. So it comes down to whether I shoot my toe off or my whole foot, lol.

I guess the sooner I back out of 2007 the better. sheeesh, I am disappointed.

Thanks again

[NeoPa]

Good analogy :D

Programming changes however, are pretty simple to cart across. They are stored as text after all ;)

Other changes can be messy of course, and maybe there are also some of those, but the code is easy.