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:
Code:
    Dim rs As ADODB.Recordset
    Dim mycon As ADODB.Connection
    
    Set mycon = New ADODB.Connection
    mycon.ConnectionString = CurrentProject.Connection
    
    mycon.Open
    
    Set rs = New ADODB.Recordset
    rs.Open "Address", mycon, adOpenForwardOnly, adLockOptimistic
    
    rs.AddNew    '****THIS WHERE THE ERROR OCCURS
    rs!Address = ">>" & Now
    rs.Update
    rs.Close
    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.

Any help would be very much appreciated.