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.