I'm a total n00b to VB, though I don't think it'll be too hard to learn. What I'm wondering about, though, is how I will connect to an ODBC database for read access with it. I'm probably also going to need to connect to an Access db for read and write access, which I am also spectacularly n00bish on. I am creating/administering the Access db right now, but I'd like to write a VB front end so that I don't have to install Access on every machine in the office.

Basically, I'm hoping someone here can point me to some good resources, free or otherwise, that will help me learn what I need to learn or at least serve as a good reference or starting point for my questions. I'll be working w/ VB 6.0, btw.

Thx in advance

5/24/2006 5:01:59 PM

Sendkeys ALT+F4

5/24/2006 5:14:50 PM

Quote :

"I am creating/administering the Access db right now"

Make sure your database is solid before you write a front-end for it.

I have one book I use for reference ... not sure how it would fair for learning VB:
http://www.amazon.com/gp/product/1884133932/

5/24/2006 6:24:24 PM

Use ActiveX Data Objects (ADODB). Really easy. Pretty much what you need is an:

ADODB.Connection - an object that manages your database connection
ADODB.Recordset - your query results

Dim Conn as ADODB.Recordset
Dim Rset as ADODB.Recordset

Set Conn = New ADODB.Recordset
Conn.Open 'use appropriate conection string and such
Set Rset = Conn.Execute("SQL QUERY HERE")

Rset.MoveFirst
While Not Rset.EOF
    'do something with your record
    Rset.MoveNext
Wend

Conn.Close
Set Conn = Nothing
Set Rset = Nothing

5/24/2006 9:29:08 PM

1.) Get VisualStudio 2005 Express C#
2.) Forget about VB6
3.) Pick up a ADO.NET book
4.) Migrate database to a real RDMBS
5.) ...
6.) Profit

5/25/2006 8:47:22 AM