dynamically link to SQL Server database from ACCESS

[jpl458]

I have an ap(Access 2010, Windows 7) that needs to be run on different PC's in our domain. The Database is in SQL Server 8 and the application uses linked tables. I would like to be able to link to those SQL Server tables in vba when the application opens, and pass the user name and password so the user doesn't have to perform those tasks. I found the following:

Public Function SQLServerLinkedTableRefresh (CurrentUser, UserPwd), so I think there are commands that would let me do this, but can't find them anywhere, and find no examples.

Any help would be appreciated.

Thanks

jpl