Really Newbie question (Visual Basic)

[skeletonkeys]

I have just installed Visual Basic 6 on my pc and also bought a new book so I can learn how to use it. I have spent all this money because i want to make a program that lets you search, read from and write to a database made in access. It appears that it should be a piece of cake, as it's only chapter 3 in the book, but I get absolutely nowhere before I get an error come up.

I have searched the forum for this, so it's obviously too easy for anyone to bother covering:



I make a generic database in access, put a table with a couple of records in and save it.

I open VB6, make a new program and put in a data thing off the toolbar on the left. I choose the right database in properties.

Then, when I go to the record source property and click on the drop down list, it gives the error "unrecognised database format" followed by the filename.

I have checked that the connect property is set to "access" and the defaulttype set to "usejet"




i think thats enough information. If you need more then just ask but I'm pretty sure its going to be dead simple.

I'm off to read the book again.

Thanks in advance,

Keys

[Doobie]

you could go to PlanetSourceCode.com and search for database.... and download a sample to see how it is done....

Hope that helps you.....

[Doobie]

Oh, yeah i have a sample database program that i made to keep track of people that owe me money ... if you would like i can send it to you.... But its in Spanglish (spanish/english) ..... very easy to understand.... let me know...

[homer15]

do you think you could list the properties for the control bar?

[doctorgonzo]

Instead of using the regular data control on your VB toolbar, trying using an ADODC data source. Go to components (Ctrl+T), and then select M$ ADO Data Countrol. Hit apply to add it to the toolbar, and then add the control it to your form. Go to the ConnectionString property and build a connection string (a little wizard will help you there, click on "Use Connection String", click on "Build", for the Provider select M$ Jet 4.0 OLE DB provider, then on the Connection tab put in the database data, and then test the connection). Then you should be all set. This works for me when the regular data control gives me that "Unrecognized format" message. Besides, there are many other advantages to using an ADO data control.

[skeletonkeys]

Thanks, that ado thing has worked, but now I'm stuck as to what to do next, as the only tutorial I have does everything the old fashioned way. Can you recommend a tutorial/example program that helps with this?

Thanks again,

Keys

[skeletonkeys]

ie. helps with searching through, adding to etc. a database.

Sorry, should've explained that.

Keys

[doctorgonzo]

Just go to Google and type in "ADO Tutorial" and you will find a bunch of info.