I am trying to make an alphabetical recordset navigation tool which will bounce the user to whichever letter they choose. I found one at www.codeave.com/asp/code.asp?u_log=104 which is useful, but I need to change the database setting from MSAccess to MySQL - the part in question is here:

accessdb="state_info"
cn="DRIVER={Microsoft Access Driver (*.mdb)};"
cn=cn & "DBQ=" & server.mappath(accessdb)
Set rs = Server.CreateObject("ADODB.Recordset"

I need this to change to target MySQL db 'Developer' - does anyone have any ideas? I have trawled the Net without any luck

Entire code can be viewed by following the link [got truncated on the forum].

Thanks in advance
Martin