Setting an Access dbase password

Results 1 to 2 of 2

Thread: Setting an Access dbase password

  1. #1
    Join Date
    Dec 1969

    Default Setting an Access dbase password

    Hi - I set a database password on an Access 2000 dbase called "clambake". When I open my connection using PWS using the script below, everything works fine. When I upload the same script to an NT/IIS4/Access 2000 box, I got an error message stating "not a valid password" on my con.Open line. The DSN on the NT box is the same. Does anyone have a suggestion for me on how to fix this? TIA<BR><BR>&#060;%<BR>&#039Create our connection<BR>Set con = Server.CreateObject("ADODB.Connection")<BR>con.Ope n "DSN=Events; pwd=clambake"<BR>%&#062;<BR>

  2. #2 Guest

    Default RE: Setting an Access dbase password

    I don&#039t know about Access 2000, but in Access 9x when you activate security you create a file called System.mda, and the path is specified to the .mda file. I assume that you would then need to upload that file as well as your database, and you would <BR>need to specify the path correctly. Best to contact your ISP about this, as they may need to do something as well.

Posting Permissions

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