Access Database Connection String & Recordset (Help)

I am passing 3 hidden fields to another page using the method="post"

Here is the next page -
<%
Dim fmMemberID, fmUsername, fmPassword
fmMemberID = request.Form("memberID")
fmUsername = request.Form("username")
fmPassword = request.Form("password")
%>
<%
Dim dbConn
set dbConn = Server.CreateObject("ADODB.Connection")
dbConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\inetpub\credencia.net\fpdb\members.mdb"
dbConn.Open

Dim rsMember
Set rsMember = Server.CreateObject("ADODB.Recordset")
rsMember.Open "SELECT * FROM Members WHERE MemberID=179", dbConn,
%>

What am I doing wrong here?

Do you have the ODBC client setup on your machine?

If not, there are a number of good threads on this site as well as Your First Database

Which has reference and guidelines on how to setup your machine for databases.

Hi,
First thing, I find it more successful if I keep this line all on one line. Sounds goofy, but it works.
dbConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\inetpub\credencia.net\fpdb\members.mdb"

Next, take the comma off the end of this line;

rsMember.Open "SELECT * FROM Members WHERE MemberID=179", dbConn,

I would also put my sql statement into a separate variable and then open the recordset using that variable like this;

src=""SELECT * FROM Members WHERE MemberID=179"

Better to refer to the variable containing the value you are looking for.
src=""SELECT * FROM Members WHERE MemberID= " & fmMemberID

dbConn.open src

I know it's 4 days after the fact, but I hope it helps.

What is the error that you get?