I have create a SQL Server Compact database from VBA in Excel. So far so good. Now I want to access the database via a recordset. here is my code.
Set recSet = New ADODB.Recordset
recSet.LockType = adLockBatchOptimistic
recSet.CursorType = adOpenKeyset
Call recSet.Open("SELECT * FROM SPAR", dbConn)
When I run this I get and error in Call recSet.Open("SELECT * FROM SPAR", dbConn):Errors Occurred, [,,,,] I have search many forums about his problem, but I still can't see where the error is from. I am using Excel 2003, and SQL Server
View Complete Post