RunCommand acCmdLinkTables Fails in Access 2007 (Error 2046)

I have recently installed Office 2007 (SP1) retaining the previous
installation of Office 2003.

I have converted an Access 2003 database to Access 2007. The database
contains the VBA code 'DoCmd.RunCommand acCmdLinkTables' to initiate
the dialog box to rebuild links to tables held in a back-end Access
database (which has also been converted from Access 2003 to Access
2007).

The code runs without problem in the original Access 2003 .mdb format
under Access 2003, yet when run in either Access 2003 .mdb format or
Access 2007 .accdb format under Access 2007 returns error 2046 with
the description 'The command or action 'LinkTables' isn't available
now.'

Refreshing the table links 'manually' in Access 2007 via the Ribbon
(External Data / Access) runs without error.

Any ideas welcomed!

Thanks, Tony.


.

Relevant Pages

  • Re: RunCommand acCmdLinkTables Fails in Access 2007 (Error 2046)
    ... RunCommand acCmdLinkedTableManager ... I have converted an Access 2003 database to Access 2007. ... the dialog box to rebuild links to tables held in a back-end Access ... The code runs without problem in the original Access 2003 .mdb format ...
    (comp.databases.ms-access)
  • Re: Using Access 97 and Access 2003 on same computer
    ... When you installed Office 2003 did you install to a completely separate ... Be aware that if you double click on your Access 97 database it will not ... > the time to deal with converting all my VBA code to 2003). ... > functionality of Visual Studio or of Access 97? ...
    (microsoft.public.access.conversion)
  • Re: Access 2002 file wont work in 97
    ... No version of Access is capable of reading files from newer versions. ... Access 97 format through Tools | Database Utilities | Convert Database. ... since the default format for both Access 2002 and Access ... > then installed Office XP. ...
    (microsoft.public.access.setupconfig)
  • message: The wizard is unable to create your data access page
    ... I've installed Office 2003 and applied all the latest patches. ... access page by using wizard. ... database (the connector icon indicates that the database is not connected - ...
    (microsoft.public.access.setupconfig)
  • Re: Using Access97
    ... > I have written a database in Access97 and wish to keep it. ... > installed Office 2000, eliminating Access. ... As long as you don't ever open Access ...
    (microsoft.public.access.setupconfig)