Cursor Location = ad Use Client sql = "SELECT * FROM tbl Quote Lob WHERE (Quote ID = " & Me!
Open sql, g Cnn, ad Open Keyset, ad Lock Optimistic If rst.
I have a problem with some of my SQL servers, but not all.
I'm not very well informed on cursors, locktypes etc, and with my boss away and the client expecting a beta version early this week, I have little time to read up.
Open "Provider=Advantage OLE DB Provider; Data Source=" & amspath & "\" & database_name & "; Lock Mode=ADS_Compatible_Locking; Server Type=ADS_REMOTE_SERVER; Table Type=ADS_ADT; Trim Trailing Spaces=TRUE; User ID=test; Password=test; Filter Options=RESPECT_WHEN_COUNTING" End With Recordset is opened like this: Set adostatements = New ADODB.
The facts, figures, reviews, records, stats, and other data presented on this page is for suggestion and information purposes only.
Page is not responsible for any incorrect or incomplete information.
This may be a limitation of the provider, or of the selected locktype.