Does not support updating
Add New rs Main(User Name) = str Query End If rs Main. You can either set the recordset properties before opening the recordset as shown or using a single statement: recordset.
If you downloaded a version of i Tunes from Apple's website, use the steps in this article.
If you can't download or update i Tunes from the Microsoft Store, contact Microsoft for help.
If you can't install i Tunes on your Windows PC from Apple's website, or if you see "error 2" or "Apple Application Support was not found" after you install the software, follow the steps below in order.
I added the above Cursor Location to see if problem went away, but it didn't. Michael Lee I have changed the above slightly but I'm getting the same results. Bob Just remove the space between faq and 222 - like this FAQ222-3670 ________________________________________________________________If you want to get the best response to a question, please check out FAQ222-2244 first'If we're supposed to work in Hex, why have we only got A fingers?
Execute Here is the Stored procedure: CREATE PROCEDURE [dbo].[nb_Get Insurance]@Patient ID nvarchar(12),@Admission Date smalldatetime ASSelect Key Id, Patient ID, Admission Date, Insurance_Name, Insurance_Number From Insurance Where Patient Id = @Patient Id and Admission Date = @Admission Date GOI do have the Cursor Location set for the connection object. (Read up on "disconnected recordsets" if you're interested.) I did an faq called "nickel tour of ado's different cursor types" (faq 222-3670, sorry, I haven't learned how to plug the hyperlink in here) if you're interested.
If I check the Lock Type right after executing a addnew to the recordset the property changes to ad Lock Read Only. There is one other thing that I thought it could be. Here is an example of the code thats loading the recordset: If rs Insurance.
The following is a chopped down version of my code... Open "Driver=; Dbq=c:\Website Projects\Exit Cash Flow\log M.mdb;" str SQL = "Select * From Main Where Username = '" & str Query & "' and Domain = '" & str Domain & "'" Set rs Main = cn. Close Set rs Main = Nothing ======= End of Code ========= .mdb;" str SQL = "Select * From Main Where Username = '" & str Query & "' and Domain = '" & str Domain & "'" rs Main. Execute (str SQL) method returns a read-only recordset. Open str SQL, cn) and that took me a few minutes to figure out why I was getting a '3001' error... If you have Windows 10, you can also get i Tunes from the Microsoft Store.If you have trouble installing i Tunes from Apple's website, download i Tunes from the Microsoft Store. Lock Type = ad Lock Optimistic Set rs Insurance = m Command. I also tried getting rid of the uniqueidentifier field and I had the same problem. Would ahaving 3 fields as the primary key affect this problem. If you want a client side cursor to be updatable, the locktype must be adlockbatchoptimistic, and you have to use the updatebatch method.
Michael Lee Hi Roy, I just found a KB from Microsoft (KB188857) that talks to that some. Changing cursortype to keyset would therefore have no effect. Its either that or open the recordset and then use the filter property to filter the data. All this is causing me more problem because I was looking to bind the recordset to a TDBGrid (Component One Grid) and if I only have a read only recordset, this does me no good at all. The cursortype is always static if the cursorlocation is client, and the latter overrides the former.