Spoke too soon
This fix
Set MyRS = New ADODB.Recordset
MyRS.Open "tblMain", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
works fine in 03, but when converted back to 97, it does not recognize the CurrentProject.Connection. Any suggestions as to what I can do differently?
OR the...