Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Using Access with VB
Name: Yin Date: March 27, 2005 at 20:59:36 Pacific OS: Window XP CPU/Ram: Pentium 4
Comment:
I need help with how to link Access and VB 6. I need to link VB forms to Access database. Do I create the database in Access itself or in VB? Also, do I need to change the setting in the ODBC( Data Sources )? Thank you.
Name: Choven Date: April 2, 2005 at 21:15:52 Pacific
Reply:
You can do either, but the easiest will be to make the DB in Access then set up the connection. If you make the DB in access, I'd use the data control and set the connections with it instead of a connection file.
There's a ton of info on making databases in VB6. You can google it or buy a beginner's book on VB. Most books for beginners have a section on connecting to an access database.
Summary: Thank you for your response IVO. I think that you understand my problem even though I wasn't thorough in my explanation. I have a client that would like to use an Access database that I developed. ...
Summary: Taking your suggestion, I examined the difference in References between the 97 database and the 2000 database. What I found was the following was not referenced in the 2000 database: Microsoft Visual...
Summary: I have created a 'Library' database using MS Access 2000 and have fronted it with forms created with VB 6 however I have come unstuck when it comes to how to code a particular query, basically I don't...
0 
