Question ADODB Recordset in Access 2007

[gem1204]

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.

Thanks
GEM

 

[boblarson]

Have you tried changing the connection from

CurrentProject.AccessConnection

to

CurrentProject.Connection

AND also has your FE/BE been put into TRUSTED locations?