How do I use Microsoft Access 2010 with Visual Basic 6 and control it?

Question

1.00/5 (1 vote)

See more:

I'm a part of a Visual Basic 6 based project. My project has been named 'Implementing Mobile Contacts in VB6 with MS Access as database'.I need to recreate the mobile contacts feature in Visual Basics 6. So I'm stuck with some problem. I'm a newbie to Visual Basics.

Here's a screenshot to two forms which I'm unable to complete
PIC-1
https://lh4.googleusercontent.com/-9Y9aviy04mE/UeBBeETH-wI/AAAAAAAAAIQ/dQEWNDe2b-s/s1072/1.jpg[^]

PIC-2
https://lh3.googleusercontent.com/-lCguBA6ITuc/UeBBerdwByI/AAAAAAAAAIU/HGxRopCO5q8/s1063/2.jpg[^]

So here's what i'm supposed to do...
1. When I click the 'ADD'(PIC-1) Button in VB, it should go to next form(pic-2) and I should be able to fill-in the text fields which in-turn should update the datagrid in the prev form(PIC-1).
2. When I click the fields in datagrid with value, the grey space should display all the details of that contact.

I have these problems..
1. I'm unable to connect to MS Access database. i.e. I could not update data added in form(PIC-2) to the datagrid( Maybe it's because the data is not going into the database itself.)
2. Need help in displaying details into gray space(PIC-1) as specified.

I use Visual Basics 6 and Microsoft Access 2010 as database. Because Access 2010 does not support VB6 I have used inbuilt Access(.mdb)using jet 4.0 to create database.
I have posted this question in many form but couldn't find a perfect solution. I'm new to VB6. Can someone recommend a solution?
If someone wants to see the project for ref. find it here http://www.mediafire.com/download/cwcjehpeb225o64/VB6.zipx[^]

I think I have provided enough details. Please mention if you need more details.

Posted 15-Jul-13 6:57am

Rodney Mathew

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

KarstenK · Answer 1 · 2013-07-15T07:25:00

Solution 1

>you better use a newer version of VB to get all the features of VB.net.

It sounds that your managers/teachers have any clue about modern software ,-)

http://www.microsoft.com/visualstudio/eng/downloads

if it isnt possible you need to go the painful way via sql. Create a connection in Access and use it from VB.

Posted 15-Jul-13 7:25am

KarstenK

Comments

Rodney Mathew 15-Jul-13 13:55pm

Thank you for your response!
I know it's really weird because our university still uses Visual Basic 6 and we are not allowed to use any other version.

I tried to use SQL view in Access 2010 but that didn't help as the database(.mdb) format was older than the presently used format(.accdb). Any other way?

KarstenK 16-Jul-13 2:57am

Tell them that is "industry standard" to use compatible programs and IDE.

And developing for VB 6 is for the Trash bin it is a "dead end street". It would also better better for YOURSELF to develop skills in VB.net. :mad: