i want to learn vba data connectivity

[prasad joshi]

can any body teach me vba dao, ado , recordset , connectivity... ..


is there any video tutorial

or any good book..........

[zmbd]

Prasad,
There are tons of good books out there that will help you to learn about DB connectivity...

Work you way thru EVERY one of these links:

http://allenbrowne.com/tips.html

I know that not all of these are in direct answer to the your question; however, these will answer 80 to 99% of every basic (and frankly some not so basic) question you could ask... some of the information is version specific however the website is active and I've seen changes being made for the v2007 and v2010

For a video series... this is not the best however, this starts from the begining of development and once you're on youtube you know that it will show a ton of related materal so you could easily spend the next year (or more) watching the various vids and never have to watch the same one twice...

http://www.youtube.com/watch?v=pikjjXnwWik

Here's some canned stuff... read thru them to see how the strings are created... because some can be fairly complex I don't mind providing a link to some examples:

http://connectionstrings.com/access-2007

I warn you now.... this is for after you understand what these are for... there are a few (I read alot) good articles on this site that you should browse thru and read - many of which will help you use the connection strings that are shown in the link. Once again, depending on how fast you read... you could spend a year or more here too! :)

THat should get you started.

[Edit] You'll need to understand the recordset object model too: http://msdn.microsoft.com/en-us/libr.../ff841663.aspx

-z