ms access+mssql tables

mase112

New member
Local time
Today, 02:36
Joined
Nov 10, 2005
Messages
7
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
 
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'
 
Is your ODBC connection at home correct (ie if you Test DataSource in ODBC connection)?
Which authentication method are you using?
 

Users who are viewing this thread

Back
Top Bottom