Connecting MS access with VB

[prabakar]

How to connect MS access with VB

[Dököll]

How to connect MS access with VB

Hello, prabakar!

You will need to do some reading:-)

Let me fetch the link.

Dököll

[Dököll]

How to connect MS access with VB

Here you go:

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

Let me know how it turns out...

[rave3085]

well the code below gives a connection to the database

dim db as new ADODB.connection

set db =new ADODB.connection

db.open="PROVIDER=Microsoft.jet.OLeDB.3.51;Data Source=" & App.Path & "\xxx.mdb;" this is for an access database, pls give your tablename in the xxx
this makes a coinnection, however u need a Recordset to actually add,delete or edit records

for this
dim rs as new ADODB.recordset
set rs =new ADODB.recordset
rs.Open "SELECT * from tablename", db, adOpenDynamic, adLockOptimistic


this makes a perfect connection and now with a more detailed program u can add and delete records.

[debasisdas]

Actually this is regarding the previous post

First of all select Microsoft ADO Object library.from Project---Reference

Next(regaring previous post)

In place of xxx instead of using tablename please use DATABASE name.

rest all is fine

and to open the recordset use TABLENAME in the SQL statment.

[rave3085]

hmm he was correct! sorry for the mistake! Do as he said!
thats it