Help!!!! Connection Issue

[DiaC]

When connecting to an access database, I have tried 2 methods and received the same results. I used an ADO data connection and a Data Environment. When connecting, with both I used the Jet 4.0 engine to connect to a db that is resident on the end users PC.
I have written and application for the Palm Pilot and I am using VB to pull the databases form the palm using the Hot Sync process. I have one form that shows the status of the Hot Sync and after the table has been downloaded this form calls a second form which contains a 'Data Grid' (using the connections listed above). When the 2nd form is opened it appears to have taken a snapshot of the data prior to the table download from the Palm. The data displayed is not the data that was downloaded. I have tried to refresh, load & unload, open & close, etc. . . to get a fresh version of the data and nothing has worked for me.
I am not new to VB, however I don't get to work with it often. Is there something that I am missing in my connection method or is there a command that I have not tried. I would really appreciate whatever help can be given.
Thank you.

[F14tomcat]

Post a the code for your connection and I will take a look at it for you. Meanwhile, did you make sure under project "references" that jet 4.0 is checked?

[Lee M.]

The problem is, that time is NOT on your side. The time it takes the palm to communicate with the host is milleseconds longer than the time the commands in code are executed. Your app calls for the data, then hops on to the next command, displaying the data. The data has not been loaded up yet, so you only get the data template.

[F14tomcat]

I pulled this from the Chuck Easttoms VB world website. I don't know if this will solve your problem, but if Lee M is correct about time then this should work.

Public Sub SlowDown(itime As Integer)

'This subroutine will simply wait a number of seconds

' for example you can place the code slowdown 1 in your app

'to make it wait 1 second. It will only recognize integer values

Dim lStartTime&

lStartTime = Timer

Do While Not Timer >= lStartTime + itime

DoEvents

Loop

End Sub

hope this helps


Jerry