Unanswered: Access 2007 error "Recordset does not support updating"
I am having a problem with this error in access 2007. The same code works just fine under Access 2003. I've broken the issue down into a very simple example:
I have a split frontend and backend. The frontend is read-only while the backend is read/write and I have one table linked in the frontend from the backend.
When I open a recordset to the linked table and attempt to add a new record I receive this error:
"Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype."
The following is my test code:
Dim rs As ADODB.Recordset
Dim mycon As ADODB.Connection
Set mycon = New ADODB.Connection
mycon.ConnectionString = CurrentProject.Connection
Set rs = New ADODB.Recordset
rs.Open "Address", mycon, adOpenForwardOnly, adLockOptimistic
rs.AddNew '****THIS WHERE THE ERROR OCCURS
rs!Address = ">>" & Now
Set rs = Nothing
I've tried using different cursortypes and locktypes but I always get the same results. I've set a watch on the recordset and it always shows the cursortype as adOpenStatic and the locktype as adLockReadOnly.
As I stated before his example works perfectly under Access 2003.