Help with ACCESS DB Connection

Results 1 to 2 of 2

Thread: Help with ACCESS DB Connection

  1. #1
    Lance Guest

    Default Help with ACCESS DB Connection

    Greetings,<BR><BR>I want to give my access database a password... but i can&#039t seem to figure out the right syntax.... Doing it on SQL 7.0 was no problem, but now I can&#039t seem to find the right syntax for a access database.<BR><BR>Any help would be greatly appreciated.<BR><BR>-----<BR>dim db<BR>set db = Server.CreateObject("ADODB.Connection")<BR>db.Open Session ("DatabaseName")<BR>------<BR><BR>Later<BR>Lance<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Help with ACCESS DB Connection

    Try this<BR><BR>dim db<BR>set db = Server.CreateObject("ADODB.Connection")<BR>db.Open "DSNname","user_id","password"<BR><BR>youd System DSN has to specify the access security db you have setup<BR><BR>check out for more useful database stuff <BR>There&#039s also plenty other info on this site and<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