Chat LIVE With Programming Experts! There Are 23 Online Right Now...

Welcome to Dream.In.Code
Become a VB Expert!

Join 244,306 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 786 people online right now. Registration is fast and FREE... Join Now!




How can i the link microsoft access to VB

 
Reply to this topicStart new topic

How can i the link microsoft access to VB, VB and microsoft access

June1982
8 Jan, 2009 - 12:02 PM
Post #1

New D.I.C Head
*

Joined: 8 Jan, 2009
Posts: 1

what should i do to put microsoft access to VB so that when i do list to VB it will get its source from microsoft access

User is offlineProfile CardPM
+Quote Post


Jayman
RE: How Can I The Link Microsoft Access To VB
8 Jan, 2009 - 01:47 PM
Post #2

Student of Life
Group Icon

Joined: 26 Dec, 2005
Posts: 8,063



Thanked: 159 times
Dream Kudos: 500
Expert In: Everything

My Contributions
I would suggest you start by reading some of the tutorials that cover this subject matter.

Tutorials Section
User is offlineProfile CardPM
+Quote Post

Nikhil_07n
RE: How Can I The Link Microsoft Access To VB
9 Jan, 2009 - 02:13 AM
Post #3

Payback Time!!!
Group Icon

Joined: 9 Jan, 2009
Posts: 1,621



Thanked: 12 times
Dream Kudos: 1200
My Contributions
CODE
adoconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=X:\XXX\xxx.mdb;"


Replace all X's

Rest of the coding is same as done for oracle....
make sure that you dont use adCmdTable for opening recordsets.

I mean

adorec1.open "Emp"...... is WRONG

correct is

adorec1.open "Select * from Emp"........ is CORRECT
User is offlineProfile CardPM
+Quote Post

etftw
RE: How Can I The Link Microsoft Access To VB
9 Jan, 2009 - 08:32 AM
Post #4

New D.I.C Head
*

Joined: 9 Jan, 2009
Posts: 8


My Contributions
Incase you are new to writing programs / scripts which interact with databases I suggest reading up on SQL, here is a good place to start: http://www.w3schools.com/sql/default.asp that page has pretty much everything you will need to know regarding SQL smile.gif
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 7/4/09 06:39PM

Live VB Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month