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.