ms access+mssql tables

[mase112]

I have a ms access file whit form's raports, and moduls i linked the tables whit a ms access database that i not have at home.
dit thit whit odbc, but when i open a table the database asks me a 1000 times for the sql server password.
I had the same thing whem i had my ms access file on the same network as the sql server but it only did this when the computer where not in the same domein.

please help

 

[mase112]

Here are the errors that i get:

Connection failed
SQLstate: '01s00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver] invalid connection string attribute

Connection failed
SQLstate: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] login failed for user 'computername\Gast'

 

[nateobot]

Is your ODBC connection at home correct (ie if you Test DataSource in ODBC connection)?
Which authentication method are you using?