I would like someone to help me in this matter:
I'm working at a Access 2002 project connected to an SQL Server 2000 database. It seems that the SQL Server user and password (i'm using SQL Server Authentication, not Windows NT Integrated Security) set in the Data Link Properties property sheet (you get to it using File menu, then Connection menuitem) takes priority over my runtime built ADO connection object. (Notice: in the Data Link Properties, the 'Allow saving password' checkbox is checked, if this information helps).