Access connection w/o DSN

Results 1 to 2 of 2

Thread: Access connection w/o DSN

  1. #1
    Join Date
    Dec 1969

    Default Access connection w/o DSN

    I know the code for a SQL connection without a DSN is:<BR>conn.Open "DRIVER={SQL Server};SERVER=(servername);DATABASE=(dbname)"<BR> <BR>But what is the code if I want to use Access instead of SQL?

  2. #2
    Join Date
    Dec 1969

    Default RE: Access connection w/o DSN

    &nbsp;<BR>There are various ways, but this one works for me:<BR><BR>Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);" _<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;&nbsp; &amp; "DBQ=" & Server.MapPath("filename.mdb")<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