Running a msaccess macro using VB

[davebhoy]

Hi there

From viewing some very useful threads here I can now successfully run an access macro using Visual Basic.

However, if a macro involves a query which has a linked table to SQL Server, how do I specify the SQL username and password so that it can complete the macro.

Any help is much appreciated, thank you.

David