I think its as simple as adding the following to your connection string
after the '...l:\research\scientist.mdb;'

'User ID=YOURUSERNAME; Password=YOURPASSWORD;'

Hope this helps

Alec

-----Original Message-----
From: Bruce Haan [mailto:bpa.haan@s...]
Sent: 06 January 2001 15:18
To: Security_asp
Subject: Using a secure Access database


I am working on my first ASP project and haven't found out how to open a
secure Access97 database.  The datastore.asp has the following line:
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
		"Data Source= l:\research\scientist.mdb; " & _
		"Persist Security Info=False"
I implemented user level security on the database file but then the
application doesn't have permission to access the database.  What do I
need to do to access the database with a specified user name and password?
Thanks,
Bruce


---
http://www.asptoday.com - the leading site for timely,
in-depth information for ASP developers everywhere.
---
You are currently subscribed to security_asp as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-security_asp-$subst('Recip.MemberIDChar')@p2p.wrox.com