how to connect ms access in visual bacis

[belly]

i want to create a table in access using vb database connection and do manipulations in it


please help

M.R.AMARNATH

[vinci]

helo friend!

you can use ADODB or ADODC to connect your database.
that is what am doing when i make connections.

you must first add MIcrosoft OLE data objects 2.8 (something like that) in your reference.
to add ADODC object, in your components you must check Microsoft active data objects. the adodc object will then be available in your toolbar.
then configure your adodc, you can use UDL, DSN (ODBC), or connection string.

bout adodb, you actually do codes for connections

'sample:
 
dim con as ADODB.Connection
dim rs as ADODB.Recordset
 
'then to make the connection
 
con.open "Provider = Microsoft.Jet.OLEDB.4.0; data source = (place here the path of your database)"
 
' with rs, this is where you write ur SQL
' sample
 
rs.open "SELECT * FROM TABLE_NAME", con, 3, 3

this is basically what i do with my connections...
hope this could help you...

just search the net about ADODC and ADODB...

enjoy programming!

[joco]

hlo vinci
what should i done to delete, update, save, edit
the files in connecting ms acces to visual basic.
can you give me a sample program?

mr. Joco Costanilla

[Devendra Karanjit]

hlo vinci
what should i done to delete, update, save, edit
the files in connecting ms acces to visual basic.
can you give me a sample program?

mr. Joco Costanilla

Please use ADOX. Here is a sample program. first reference to msadox.dll at sytem file and use the following code.

Sub AddTable(tablename As String)
Dim tbl As New Table
   Dim cat As New ADOX.Catalog
        Dim idxNew As New ADOX.Index
 
'Open the catalog.
 
   cat.ActiveConnection = ActconnectionSubject
      tbl.Name = tablename
 
   tbl.Columns.Append "QN", adInteger
   tbl.Columns.Append "ChapCode", adInteger
 
   tbl.Columns.Append "Question", adLongVarWChar
   tbl.Columns.Append "OptionA", adLongVarWChar
   tbl.Columns.Append "OptionB", adLongVarWChar
   tbl.Columns.Append "OptionC", adLongVarWChar
   tbl.Columns.Append "OptionD", adLongVarWChar
   tbl.Columns.Append "CorrectAnswer", adInteger
cat.Tables.Append tbl
End Sub

[Saf4]

hi guys,

I was wandering if anyone could help me out im trying to connect my visual basic project to access databse table, where it has to check if the username and password exit can some one please help me out.

[lotus18]

hi guys,

I was wandering if anyone could help me out im trying to connect my visual basic project to access databse table, where it has to check if the username and password exit can some one please help me out.

http://www.thescripts.com/forum/thread733529.html