Access connection to coldfusion with username/password

[sa-txweather]

My server requires me to connect to Coldfusion to my .cfm pages using a
username and password set up in Access. Please tell me how to set up the
username/paswored feature in Access, and how to connect it to coldfusion.
Please tell me the code how to connect the .cfm page to the DSN, is it
something like:

<cfquery name="Recordset1" datasource="DSN name here" username="DSN
name-reader=username" password="DSN name-readerpassword=password" > :confused;

[drew222]

Well, I don't really use Access at all, but I will try to help. Within Access,
go to Tools->Security->User and Group Accounts. This will allow you to
create/modify user accounts. Create an account that you need (i.e. User=Test,
Password="test1")

In your ColdFusion QUERY line,

<cfquery name="recordset1" datasource="DNS" username="Test"
password="test1">

that should do it. You don't need the DNS pre-appended the the information.

I hope that helps,