link table manager, plz help ...

[Guest]

Hi all,

I have a problem with my sql server database logon.
I linked my access mdb file to the sql server on the network (using the
link-table manager), setting the Data Source ODBC > SystemDSN to my server.
My code runs fine accessing the linked sql server.

However I find that whenever I open my access file and run my code, ie. this
line e.g. "set db=db.openRecordset(strsql)" for the FIRST TIME, it will
PROMPT ME for my sql server username and password. Why is this so ? I always
thought that when I set the DSN and linked the db tables to access using the
link-table manager, I wouldn't have to logon each time to the sql server.
This happens each time when I am accessing each of my tables for the FIRST
TIME.

Thanks.
Andrew.

 

[Guest]

To over come this problem, when you set the ODBC connection, change the
connection to Authentication instead of login (user and password), that way
the user name will be the user that login the computer

 

[Guest]

Hi,

I solved the problem, seems that I did not tick the "save password" tickbox
when I used the link table manager to link my db from the sql server.

Thanks for your reply anyway.

cheers,
Andrew.