Password on Access database

Results 1 to 2 of 2

Thread: Password on Access database

  1. #1
    Peter Poulsen Guest

    Default Password on Access database

    I have an Access database with password, and I have been told I should make a DSN-less connection like this:<BR><BR>SET conn = Server.CreateObject("ADODB.Connection")<BR><BR>con n.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:database.mdb; PWD= password"<BR><BR>It is working fine on my Personal Web Server, but when I upload to my provider, who is running IIS, I get a error message that says that it is wrong password. Can anyone help?

  2. #2
    Dave2000 Guest

    Default RE: Password on Access database

    You may want to try putting in a userid (UID) as well. That could be the problem. Also, I would use Server.Mappath to reference your database location. The server may not store the DB on the C drive.

Posting Permissions

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