How can I get Access 97 to use the username and password that I send in the connection String? <BR><BR>I can connect with the database that has security set up giving a different username than the default &#039;admin&#039; access rights to the tables. However, I am only granted &#039;admin&#039; rights which are non- read on the tables even though I have sent the correct username and password in my connection string.<BR><BR>The connection string that I have used is-<BR>DRIVER=Microsoft Access Driver (*.mdb);DBQ=database location;UID=username;PWD=password;<BR><BR>Thank you for any help.