How to retrive the Data that is stored when MS access is the backend

[Kannan07]

I have prepared the form and MS access is the backend. I have converted the VB application to an .exe file. The form seems to execute correctly. But i do not know how the data is saved. I find a file Table1 ( which is the name of the Table that i use in Access) , but I am unable to open it in MS Access, Excel or any other application..pls help.

[Killer42]

How is the database connected to the form?

What version of VB are you using?

[Kannan07]

I have used ADODC Control and the Version is VB 6.0

[Killer42]

I have used ADODC Control and the Version is VB 6.0

I'm not familiar with the ADODC, but I believe it works similarly to the original Data Control. That is, you place it on the form, set it up to point to the database, and choose a data source (table/query). Then you set the properties of controls on the form to connect them to specific fields within that data source. The updating of the table can happen more or less automatically, by modifying the control contents and navigating via the adodc.

If you can see a file with the name you are trying to use for the table, then it sounds as though you have written code to try and save data to the table. Perhaps you need to brush up on the documentation for the data control (and ado data control).

It might help if you can show us the code which is supposed to save the data.

P.S. If you get impatient (as anyone would, I suppose) after a couple of days with no response, please just put a message in the thread to bump it back to the top, don't go to Private Messages. It's best if everyone can see that the thread is still active, not just me. (Plus I don't read my PMs very often.)