ADO for beginners

[EliseFreedman]

Hi

I have been using MS Access and VB for several years now but am now trying to extend my knowledge to include ADO. However, I am really struggling. I am only wanting to do basic tasks at the moment for example Connect to a database using ADO(Can do this), add records, delete records, move to the next record etc. I have been using the book "Visual Basic Developers Guide to ADO". However, it seems to be geared to using SQL Server which we are not yet using. Can anyone recommend any other books or resources on the internet

 

[BlackburnKL]

There are some differences in syntax for SQL strings used with Access vs SQL Server, but most things that work in Access will also work in SQL Server.

I know that wasn't what you were looking for, but let me explain. In Access, you can create a query. One of the options is to view it in SQL. That code can be transferred directly VB and work on your Access datbase with few exceptions. I usually remove the ";" from the end of the strings.

Those same commands will also usually work for SQL Server, although it isn't 100%. BlackburnKL

 

[zemp]

You can look at some free tutorials. Try

http://www.w3schools.com,

http://www.freeskills.com,

http://www.juicystudio.com/tutorial/vb/database.html

http://www.galahtech.com/forums/showthread.php?s=&threadid=1675

for ADO tutorials. Thanks and Good Luck!

zemp