|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Password protection on MS Access and ASP |
|
From: |
John |
|
Date: |
2/8/2000 10:19:16 AM |
|
IP: |
194.217.56.150 |
Hello,
I am trying to password protect an Access database that will be accessed trough the web.
I need to stablish the ways of doing this using DSN, DSN-Less and OLEDB. I have all working but OLEDB is always giving an error:
Error #=-2147467259
Error desc. -> Cant start your application. The workgroup information file is missing or opened exclusively by another user.
I set the password for the database and I am using this:
Configuration for Sytem DSN (OK)
ConnStr = "DSN=STORE;uid=;pwd=guess"
Configuration for file DSN-Less connection (OK)
ConnStr = "DBQ=C:\db\data.mdb;Driver={Microsoft Access Driver (*.mdb)};uid=;pwd=guess"
3. Configuration for OLDB drivers (ERROR!)
ConnStr = "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=C:\db\data.mdb; User ID=;Password=guess"
conn.open ConnStr
I know it is getting the password correctly as if I change it then I get a "incorrect password" message. Nothing changes if I specify a user.
Any ideas of how can I do this? or what can be causing this?
Thanks a lot!
John.
|
Follow Up - Re: Password protection on MS Access and ASP - Mike B 2/23/2000 11:07:22 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
