Connection to a password protected Access DB

[diarratech]

What is the proper syntax to access a protected db in access?
The folling code gives me a page not found as soon as I add
atabase Password= password
Here's my code in global.asa

<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
Application(&quot;connection&quot = &quot;Provider=Microsoft.Jet.OLEDB.4.0atabase Password= password; Data Source=&quot; & Server.Mappath(&quot;data.mdb&quot & &quot;;&quot;
End Sub
</SCRIPT>
Thanks

 

[TechnicalAnalysis]

Try this

Dim objConn
Set objConn = Server.CreateObject(&quot;ADODB.Connection&quot
objConn.ConnectionString = &quot;Provider=Microsoft.Jet.OLEDB.3.51; Data Source=&quot; & Server.Mappath(&quot;data.mdb&quot & &quot;; User ID=UserID; Password=Password&quot;

Regards

http://www.technical.analysis.dingojunction.com