how to link ms access with .net studio 2003??

Question

urgent!

Answer 1

What do u want to do? Stroe and retrive in & from ur ms access database?
if so u should define some connectors:
Dim con As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader


and use them to connect.

Answer 2

I suppose you want to create a new Connection String?

If yes then Do the Following:
1>From View Menu Select "Server Explorer".
2> Now Right Click in "Sever Explorer" and select Add Connection.
this will Provide you a way to create a Connection For your DataBase.

Alternatively the method is explained in the Articles at the Below mentioned Link:

Also go through the Links:
http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/
http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/1/


These will surely help you :c)

Answer 3

Dim MyCon As New ADODB.Connection
Dim MyRs As New ADODB.Recordset

Private Sub Form1_Load(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase.Load

MyCon.Open("Provider=Microsoft.jet.oledb.4.0; Data source=c:\A.mdb")

MyRs.Open("select * from emp", MyCon, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
msgbox "open"
End Sub

To learn how to connect
look at the following website
Connectionstrings.com