Current recordset does not support updating asp
Connection, o Rs As Recordset Set o Conn = New adodb. Open DSN On Error Go To handler Set o Rs = New Recordset o Rs. Open Query, o Conn, ad Open Static, ad Lock Read Only Set o Rs. Close Set o Conn = Nothing Set Get Recordset = o Rs On Error Go To 0 Exit Function handler: Set o Rs = Nothing Set o Conn = Nothing On Error Go To 0 End Function I works for simple recordsets, but not with multiple recordsets... I get server-side cursor by commenting out the following lines 'o Rs. The Recordset object is an essential component in Access development, but it often trips up even experienced developers.When both libraries are referenced and both libraries support an object, VBA will assign the library with the highest priority. Explicitly referencing each object's library when you declare the object is better: Moving through the records in a Recordset is a common task, but doing so comes with a few hazards.Using any move method will generate an error if the Recordset object is empty.But it's easy to go astray, and there are a number of mistakes that even experts make. Often, we're unaware of a subtle nuance between the two object libraries, Data Access Objects (DAO) and Active X Data Objects (ADO).No matter how experienced you are, it's difficult to commit every little behavior and requirement to memory.Connection, o Rs As Recordset Set o Conn = New adodb. Open DSN On Error Go To handler Set o Rs = New Recordset o Rs. Open Query, o Conn, ad Open Static, ad Lock Read Only Set o Rs. Close Set o Conn = Nothing Set Get Recordset = o Rs On Error Go To 0 Exit Function handler: Set o Rs = Nothing Set o Conn = Nothing On Error Go To 0 End Function I works for simple recordsets, but not with multiple recordsets... To solve the problem, please don't close the connection to the database until you don't need to use the all recordsets.Add another method to close the connection can be used.
The previous technique uses BOF and EOF to expose an empty Recordset before code can generate an error.This may be a limitation of the provider, or of the selected locktype. Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Well I finally found this: 'Set the cursor type property of the record set to Dynamic so we can navigate through the record set . -Corey Could you also post the query that populates the recordset, or, if it's just a table name, check that the ASP login (the SQL account usp by the ASP application to connect on your DB) has sufficient rights to update this table Yes - I did check the SQL user info. As far the query - I honestly would not know where to look. Melih SARICA Well it is rather long, but I posted them here: was hoping that it might be pretty easy & someone had ran into this "upgrade" in the past. -Corey In Line 588 as u see ure using the SQL statment like " str SQL = "SELECT TOP 1 " & str Db Table & "Topic.* FROM " & str Db Table & "Topic "" U cant add a new Row in to a Select Query which is used as Top clause . Update 'Re-run the Query once the database has been updated .Luckily, you can avoid some of the most common mistakes if you just plan for them.ADO is the default object library for Access, but DAO is still available.