Re: [MSAccessProfessionals] Officelink from MS Access 2003 not working in MS Access runtime 2019 #'

Sarah,

 

I have an Access 2003 mde that does Excel automation. It works with Access 2007, 2010, 2013 full and runtime as long as there is a working (licensed) version of Excel installed.

 

NOTE:  I use late binding for automation of other office apps to allow it to work with whatever version of the other office apps installed.

 

Have you verified they have a licensed version of Excel working?

 

Can the user of the new computer open Excel to a new blank workbook? If not, that is probably the issue.

 

If I remember correctly, the office links you are using do not actually use any type of application automation. Access writes to a file format that is compatible with the target office app. After the file is created, Access tries to launch the other office app to open the file.

 

I would check to see if the file is being created, even though it does not open. If the file is there, Access is working fine and the issue is with Excel.

 

 

Boyd Trimmell

Microsoft Access MVP 2010-2015t

 

 

 

From: MSAccessProfessionals@groups.io [mailto:MSAccessProfessionals@groups.io] On Behalf Of novice012000
Sent: Wednesday, November 18, 2020 9:25 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Officelink from MS Access 2003 not working in MS Access runtime 2019 #'

 

I have a split database written and compiled in MS Access 2003. Every report has a toolbar with Excel Office Links.
One new computer is running the database with MS Access 2019 runtime. The program works fine, however the Excel function on the toolbar does not work.
I dont have time right now to convert this database to a newer version of MS Access
Can I do anything in MS Access 2003 to make the Excel Office Link work with 2019 ?

As always all help is greatly appreciated.
Thanks
Sarah