Starting a database program

Xkape · April 17, 2003

Hi everyone.

I am very new to Vb and I am interested in designing a program that requires a database. In Vb 6 you had a choice. In .NET i'm not to sure if there is anything other than sql. Can you still use Access with vb.net? Also, can someone tell me if there is a good book or online tutorial for building a small database?

Not asking for anyone to write my code, I just need some direction.

Thanks kindly,

J

jfackler · April 17, 2003

Yes you can still use acess.

Here is a basic on database design....very basic.

http://hotwired.lycos.com/webmonkey/99/13/index1a.html

Jon

Xkape · April 18, 2003

Thanks, that helps.

Do you know of a place that is a little more up to date?

And that still talks about Access. I can't have a pws not on Xp Home. So I am using Access for my database. I'm trying to make a database of all my mp3's, so that you can search with this program and it gives me the location and it will tell you the year, the artist, album and any notes you may type in, and it will add it to the db and if you get new mp3's i am wanting it to let you add it to the db. Any ideas where I might find an example?

That uses Access and not Sql? I mean I don't have a web server or do i have access to one.

Thanks for all the help

James

hog · April 18, 2003

when you create your data adapter you can use a query designer like that in Access but with less bells and whistles if you don't want to type the sql yourself