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

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

P: 3
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.
Apr 25 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 5K+
P: 8,434
How is the database connected to the form?

What version of VB are you using?
Apr 25 '07 #2

P: 3
I have used ADODC Control and the Version is VB 6.0
Apr 25 '07 #3

Expert 5K+
P: 8,434
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.)
Apr 26 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.