I am getting an out of memory run-time error '7' when I call the save method of the ADO Recordset object. I have tried this using VBA code in Excel and Access and I get the same error. I have also tried using ADO 2.6 and 2.8 and I get essentially the same error. I have also tried connecting to MSAccess database and Visual Foxpro database and I get the same error. However I do not get an error when saving changes in Access or Foxpro when using direct access or ODBC. Please could you help me resolve this problem? It's driving me nuts! I have managed to reduce the code below to the most basic version I can to reproduce the error. My machine is running Windows XP Pro SP3 and I am using Office 2007.
Dim connAdo As ADODB.Connection
Dim rstTest As ADODB.Recordset
Set connAdo = New ADODB.Connection
connAdo.Open ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\develop\database3.accdb;Persist Security Info=False;")
Set rstTest = New ADODB.Recordset
rstTest.Open "table1", connAdo, adOpenDynamic, adLockPessimistic
rstTest.Fields("field1").Value = "Test"
rstTest.Save '' THIS LINE CAUSES RUNTIME ERROR