Connecting to a Access Database with ASP.Net

Hello everyone,
I was wondering if someone could help me. I am trying to connect to a Access
database with ASP.Net. I have a book titled "Dreamweaver MX 2004 and Database"
by Sean R. Nicholson and it's been a really great book however for some reason
I am unable to connect to an Access Database with ASP.Net. According to the
book it says to go to the Database connection and select OLE DB connection from
the plus sign. Then give the database connection a name and then select build.
It then loads the Data Link properties and I am supposed to go to provider and
select Microsoft Jet 4.0 OLE DB Provider then on the next tab browse to where
the file is. I didn't have a username and password. I test the connection and
it works fine. Then I press ok and it takes me back to the OLD DB Connection. I
press test again and I get "'c:\inetpub\wwwroot\access.mdb' is not a valid
path. Make sure the path name is spelled correctly and that you are connected
to the server on which the file resides."

I just browsed to the actual file and it says the paths not valid? I can copy
the path into the run command and it comes up fine. If anyone has any idea on
this one it would be appreciated for I am about to rip my hair and give up on
ASP.Net.