navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Using a password for updates for an Access DB?

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Using a password for updates for an Access DB? 		Page: [1]
 
dabney7

 

Posts: 8
From: Indianapolis, IN
Status: offline

  		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

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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.


(in reply to dabney7)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Using a password for updates for an Access DB? 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.