Ms-access – How to use an Access 2003 mde with Access 2007 and keep the custom menus/toolbars

ms-accessms-access-2003ms-access-2007

Please describe the exact steps required to use a compiled Access 2003 mdb with the Access 2007 runtime and retain my custom menus and toolbars so that they look the same as they did with the 2003 runtime. I've tried following the various incomplete instructions around the web, but I either end up with my menus/toolbars on the ribbon's ugly looking Add-ins tab, or they fail to appear altogether.

Best Answer

See Jeff Conrad's page How do I get my existing legacy menu bars and toolbars to work in Access 2007? Right now they all show up on the Add-Ins tab.

BTW the probably two best sites on converting to Access 2007 are http://allenbrowne.com/Access2007.html and http://accessjunkie.com/faq2007.aspx

Related Solutions

Ms-access – How to create an Access 2003 MDE programmatically or by command line in Access 2007

Try this:

Dim objAccess As Object
'Create the Access Automation object
Set objAccess = CreateObject("Access.Application")
'Now call the undocumented function...
objAccess.SysCmd 602, cstr(strPathSourceMdb), cstr(strPathDestinationMdb)
Set objAccess = Nothing

Here is a link (with more undocumented features).

Sql – Upgrading from Access 2003 to Access 2007 and SQL Server

It doesn't matter. I would go to access 2007, let the 2007 do the migration, check everything, and then go for the sql server. But - nothing will happen if you take the other way. I think it will be easier to disconnect the mdb and connect to SQL in Access 2007, Rather than in 2003.

Best Answer

Related Solutions

Ms-access – How to create an Access 2003 MDE programmatically or by command line in Access 2007

Sql – Upgrading from Access 2003 to Access 2007 and SQL Server

Related Topic