By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,534 Members | 865 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,534 IT Pros & Developers. It's quick & easy.

Updating Dataset while Form Open

P: n/a
We have a form that has a dataset on it and we send commands through tcp to
tell each program to update their database but we are running into problems
when it runs the update below it locks up the program. Are we doing the
update process right below. Can we update a dataset and reload it while the
form is open.
Thanks

Private Sub updatework()

Try

Me.UpdateDataSet()

Me.daConn.Open()

Dim Login As New clsLogin(Me)

If Login.NewWO Then newwo = True

If Me.newwo Then

Me.LoadDataSet()

End If

Login = Nothing

openPOP("Your Work Orders are up to date", False)

Catch ex As Exception

End Try

Me.daConn.Close()

End Sub
Nov 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.