So are you trying to execute a stored procedure from Access?  That would typically be the case where you pass parameters to SQL Server.  We typically define an ADODB connection,...

You did start a new post, but not a new thread.  In answer to your most recent question, Access 2013 and 2016 do not support ADP projects, but Access 2010...

On the servers where it doesn't work, do you get any sort of error message?

Also, what security model are you using?  Trusted_Connection=Yes suggests it is integrated security.  But...

You first need to define WordApp as an "object" and then set that object to be a Word using the CreateObject command.  Since you are tinkering with automation the tutorial...

OK - start the Access database while holding down the SHIFT key so you have full menus and the Navigation Pane.  Click on the "ribbon" tab for Database Tools, and...

rf44 has identified the problem I believe - a short-coming of the SSMA.  If you have an installation of a recent version of Access, there is an upsizing tool that...

Have you created an ODBC data source to the SQL Server database?  That is the only way to connect an Access database in the .accdb format to tables in SQL...

Are you expecting queries, forms and reports to be upsized to SQL Server?  The only thing that the SSMA deals with are tables that are stored natively in the Access...

As this...

What I suggested, perhaps obliquely, is that you don't need to run code to do what you are trying to do if you have the table actually linked into your...

In addition to the comments of others, I should point out that support for ADP projects was removed in Access 2013. If you have some clever user install 2013...

Since you are now trying to connect to SQL Server, you will likely need to setup an ODBC Data Source on the system in HR - has that been done?...

Is there a reason you...

Unfortunately, Access queries use a different syntax, and in most cases other than action queries, are used as the basis for forms and reports. So you may be able...