Access Microsoft Access 2000 through VB 6.0

[HebieBug]

Have already headed out and bought all the latest books on VB 6.0 but none of them go into detail on connecting to Microsoft Access 2000. They make their connection through some GUI button in the toolbar which is nice if you like your form to operate the same as the forms in Access.
What we would like to do is be able to connect to the database and then access specific areas of the tables. An example of what we are tring to do is for the user to enter data into a form (VB) and then push submit..
Code should then connect to the database (which is password protected)create a new record and then place all data in relevent area..
If anyone can help with this small problem? If they have a copy of a finished project or know of one on the net then even better..
Herb

 

[HebieBug]

Or better yet if anyone has a copy of something similar could they send me a copy uncompiled to
Henrymaher@yahoo.co.uk

 

[BlackKnight]

Hi,

First, you should make sure your VB6 is Service Pack 4 or 5. Secondly make sure ADO 2.5 is referenced in your project. Thirdly, you have bought all of the wrong VB6 books. <g> Try one that involves databases and VB6 like:

Professional Visual Basic 6 Databases
Charles Williams
WROX Press Ltd

http://www.wrox.com

=========================
Professional ADO 2.5 Programming
WROX Press Ltd

http://www.wrox.com

Have a good one!
BK

 

[HebieBug]

Nice of you black Knight will be heading off to the book shop to find some books relating to the specific subject