VB.Net and Access

[shersu]

Hi,
I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it? Please give me a start up.

Thanks

[si_the_geek]

Check out the Database Development FAQs/Tutorials (at the top of this forum), particularly the "VB.Net" and "Access" sections.

[Minolwen]

This may be a matter of opinion so take it for what its worth...

I strongly recommend you do some reading/research on how to build an efficient database before taking any further steps.

Then I would sit down and plan the entire database as it needs to be built for the application you wish to run.

Now with the database being built, I would put the winforms together for your application (if that is the route you're going to take) including all textboxes, labels, etc... A full interface.

Finally, apply your code.

--

The reason I say this is I feel that to many people design their database around their application, when it should be done entirely opposite of that. The efficiency of your database is key, as the forms for it are nothing more than a face to make the information easier to read/access by the user.

As for the planning of your database, this is probably the most important part of the entire project and as such, the most difficult for some. There are actually several applications on the net that help you with this, or you could do it using pen and paper like I do. I have to say though, normally by the time I'm done with the pen and paper method it always seems to be about 1-2 pages of information spread out across 9 pages in an organized chaos fashion that only I could decypher from.