Using a password for updates for an Access DB? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

dabney7 -> Using a password for updates for an Access DB? (3/10/2001 15:23:00)

I have my ASP working to update the access database but I now want to add a password to the database so I can protect the data from just anyone updating the records. I just don't know the correct syntax I need to build into my SQL statement in order to pass the password to Access. Any help would be appreciated.

Thanks




Spooky -> RE: Using a password for updates for an Access DB? (3/10/2001 16:10:00)

You have to protect the page that the update is on, Access passwords are for the access file only.

To open an Access file in a web environment, you can only use the anonymous IUSR account.

So, to open a database, you include the password / user in the connection string.

Hence everyone can then open it!

You need to be able to script a password to enter the page to do the update.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
6.201172E-02