Pls provide a guide for linking MS Access 2003 DB to VB .net 2k5.

Hello there,

I saw a new features in VB.net 2005 which is the Data Sources (just next to Solution Explorer). Well, I had created a Access database with MS Access 2k3.

In the DB I already did the 'format' of DB too. For eg, one of my row:

Gender, then I assigned 2 value in it which is Female & Male.

Then when I open this DB in Access 2003, it working fine perfectly. It also had all the 'format' as I mentioned above.

Now, I used the Data Sources in VB.net 2005, it can succesfully linking this Access DB into it. Then after linked I just select the DB Table with Details control and direct drag and drop it into my new form2.

So now it got all my Controls in the form2.
But now my question is I can't get the validation done from Access 2003, like the Gender example, it can be select a combobox but it inside without the value Male & Female. I really need to know how can I get the 'format' from Access into VB to work How can it included also the value (Female & Male) in the combobox which just dragged from the Data Sources Pls provide a small tutorial or guideline, thanks, I really need help for this.

P.S: I totally a newbie in VB.net, now I need to develope a easy Employee project, so I wish anyone here can help me out, Very Appreciated for ur answer!

Answer this question

Pls provide a guide for linking MS Access 2003 DB to VB .net 2k5.

HaiLV
Hi Chris,
The validation information defined in Access isn't pulled into the Visual Studio environment. So, you'll actually have to provide this information within your application. For instance, you can use a comboBox to provide the information for the user to select from.
This really isn't a good forum for teaching the product, but rather a means to provide quick answers. Please take a look at http://www.windowsforms.net for some great tutorials.

Hope this helps,
Steve
Pls provide a guide for linking MS Access 2003 DB to VB .net 2k5.

Answer this question