The small problem is that it returns an error that says: Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. /newbudgetamountprocess.asp, line 32 I would be in your debt if you could help me with the error as I have been at this all day.
When I first started working with ADO in ASP I ad the same problem.
Ms-access Database and excel VBA in the same PC its working perfectly. Open "SELECT * FROM T_Booking;", cn, ad Open Dynamic, ad Lock Optimistic With rs .
Most of the easy to find documentation mentions setting the cursor type of the recordset object.Hello, I searched for the solution, but I couldn't find a clear answer. This may be a limitaion of the provider, or the selected locktype." I have researched the locktype enum and the provider information. occuring error like "current recordset does not support updating. this may be a limitation of the provider" Dim cn As New ADODB. Recordset Dim db As Variant Dim str SQL As String Dim w Sheet Name As Variant db = "\SIMPLAN-SWATHI\Users\mgt\dbdata.accdb" //Network DB path cn. Access 2007 introduced major new functionality in both the engine and the interface.