Connecting to linked tables remotely

[whitetiger]

Hi,

I have never been able to connect to the linked tables(Access linked to SQL Server) from home(remotely), despite the fact that I am tunneling through a VPN. My friend suggested I use the method below, but it is also not working (I get an error saying that this is not a trusted server). Do you have any thoughts?

This is the method I use

Open Access.
Choose the option, select a project with exsisting data.
Put in the name of the sql server: XXXXSQL.
Choose the option that says use Integrated Windows security.
Put in the name : DatabaseName
Test the connection and say ok.
This will pull all your data for you.
Try to update your records using this option.
Rememebr if you delete a table here , you would delete the actual table. You have to be careful with this since it is a mirror of the sql database not a live link.

Thanks

 

[whitetiger]

I have done some digging around, and got the following explanation for why the connection is not trusting the server….

“The SQL Server system administrator must have associated your Windows network ID with a SQL Server login ID.”

Is there anything I can do?

Thanks!