Updating a database with vb6 Fre text sex chat

25-Mar-2016 14:18

Note that if Field_A is your primary key, then you shouldn't change it. Sub Commit Test() Dim C As String Dim I As Long Dim J As Long Dim RS As Recordset Dim Beg Time As Date Dim End Time As Date Beg Time = Now() Set RS = Current Db. Now, the question is- can you think of an Access function which creates the required Sort_value?

This should speed up the processing of your records..... I am establishing the record count by running an SQL query in SQL Studio Manager. Yeah I realize that sorry, just had to take the opportunity to make the suggestion. I would suspect there is NOT an extra row being created.I will greatly appreciate if anyone shows me any code sample or just a strategy. Otherwise, all your table would be rearranged each time you updated a few records, which would be a lot of work for your HD / processor. Open "SELECT * FROM List", conn, ad Open Static, ad Lock Optimistic Rs! Path & "\Database1.mdb; Persist Security Info=False" Rs.

This should speed up the processing of your records..... I am establishing the record count by running an SQL query in SQL Studio Manager. Yeah I realize that sorry, just had to take the opportunity to make the suggestion. I would suspect there is NOT an extra row being created.

I will greatly appreciate if anyone shows me any code sample or just a strategy.

Otherwise, all your table would be rearranged each time you updated a few records, which would be a lot of work for your HD / processor.

Open "SELECT * FROM List", conn, ad Open Static, ad Lock Optimistic Rs!

Path & "\Database1.mdb; Persist Security Info=False" Rs.

Update int Write Count = int Write Count 1 End If rs2. Active Con, ad Open Static, ad Lock Pessimistic Do While Not rs.