By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,640 Members | 2,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,640 IT Pros & Developers. It's quick & easy.

i want to learn vba data connectivity

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


is there any video tutorial

or any good book..........
Aug 17 '12 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
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
Aug 17 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.