I have decided to convert my old online mdb website to accdb.

Hopefully this is just a meeter of changing the asp

Currently looks like this:

Quote

 

<%
  Dim adoCon2 
  Dim rsdbase
  Dim strSQL2
  Set adoCon2 = Server.CreateObject("ADODB.Connection")
  adoCon2.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("data/mydb.mdb")
  Set rsdbase = Server.CreateObject("ADODB.Recordset")
  strSQL2 = "SELECT institute.institute_title, institute.institute_id FROM institute ORDER BY institute.institute_title;"

  rsdbase.Open strSQL2, adoCon2
  Do While not rsdbase.EOF

 

Anybody got any ideas on where I can a tutorial to help write the new 'link' code?

Get claude.ai to do it for you.