Open Access 2000 database

Results 1 to 2 of 2

Thread: Open Access 2000 database

  1. #1
    Join Date
    Dec 1969

    Default Open Access 2000 database

    Hello,<BR><BR>i&#039;m always use Access 97 databases for my asp pages without DSN.<BR>Is there a difference to open and use access 2000 ?<BR>this is the way how i open the 97 database:<BR> Set oConnect = CreateObject("ADODB.Connection")<BR> oConnect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("..TestTablesCadNet.mdb")<BR><BR> Set oRSpas = Server.CreateObject("ADODB.RecordSet")<BR> oRSpas.Open "select * from ADMLOGIN", oConnnect,2,3<BR><BR>Thanks,<BR>Jan<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Open Access 2000 database

    exactly the same<BR><BR>if you were using OLEDB you&#039;d need to specify OLEDB.4.0 rather than 3.51, but you&#039;re not.<BR><BR>j

Posting Permissions

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