Database Passwords

Results 1 to 2 of 2

Thread: Database Passwords

  1. #1
    Join Date
    Dec 1969

    Default Database Passwords

    I want to password protect my database so that you can&#039t simply download it by typing in the URL location. My current connection script looks like this:<BR><BR>Set Connect = Server.CreateObject("ADODB.Connection")<BR>Connect .Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("MyDatabase.mdb")<BR><BR>This works fine when there&#039s no password on the database, but when I require a password (by assigning one in MS Access), it doesn&#039t work anymore. What do I need to add to this script to make the connection work (with the password). Or else - is there a better way of going about all of this?<BR>

  2. #2
    Kevin Guest

    Default RE: Database Passwords

    Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("MyDatabase.mdb")&";pwd=password" <BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts