I have an MS Access 2003 database that has code in the open event of a form that sets the recordset to an adodb recordset.
This is the code
Dim sql As String
sql = "Select * from tblQuickenData"
Dim RsClone As ADODB.Recordset
Set RsClone = New ADODB.Recordset
RsClone.Open sql, CurrentProject.AccessConnection, adOpenDynamic, adLockOptimistic
Set Me.Recordset = RsClone
When I open the form with MS Access 2003 the records are updatable...I can add, delete append. When I open the same form with MS Access 2007 the records are read only.
Can someone tell me why this is and how to fix it? I have a lot of databases that I've developed using MS Access 2003 and I would really like to convert them. I've used Access for well over 10 years. There are a lot of great new things in Access 2007, but there are also a heck of a lot of things that don't seem to work.