Re: After creating a data connection with VB 2005 wizard, how do I insert record into Access 2000

Sorry, the VB in this newsgroup's name refers to VB6 or earlier.

Try posting to a group with dotnet in its name, such as
microsoft.public.dotnet.languages.vb.data

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Lawrence M. Seldin, CMC, CPC" <lmseldin@xxxxxxxxxxx> wrote in message
news:39i044d3dqdn0q7nbo8nht5p68su0qdij0@xxxxxxxxxx
I am using VB 2005 and MS Access 2000.

- I created a console application in VB 2005, then chose data, add
datasource,
database, new connection.

- datasource: Microsoft Access Database file

- Database filename = c:\data\test.mdb

- Connectionstring = Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\data\test.MDB

- Save connection as: testConnectionstring

- dataset name = testDataSet

- tablename = newtable, field = FieldA with
Dim FieldA as integer


Can someone give me the code tie the above Database, table, dataset and
connection string above, to
insert a record into the above database table. The idea, is that I created
the objects above, but
don't know how to tie it the the statements needed to insert a record into
the access table.


Thank you,



Lawrence M. Seldin, CMC, CPC

Contributing writer for FUTURES Magazine
Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM
Author of POWER TIPS FOR THE APPLE NEWTON and INTRODUCTION TO CSP

NOTE: To send me an email, remove TAKEOUT from my email address:
larryTAKEOUT@xxxxxxxxxx

NOTE: My web home page: www.seldin.net


.

Relevant Pages

  • Re: OleDbConnection does not release Access database
    ... this is not a web app. ... a Microsoft Access database. ... the database connection, but that seems a little excessive for what ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Albert Kallals article WAN w/Access
    ... connection went down, it could introduce funky stuff into your database. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: Using VB 2005 to insert record into Access 2000
    ... This newsgroup is for the compiled version of classic Visual Basic 6.0 and below. ... database, new connection. ... Save connection as: testConnectionstring ... Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM ...
    (microsoft.public.vb.general.discussion)
  • test connection failed
    ... Using Microsoft access, ADO and D6. ... Using a .udl file for the connection to ... the NT4 machine, and copied the .udl, the database, and the exe to the NT4 ... When testing the connection, on the Provider tab I selected ...
    (borland.public.delphi.database.ado)
  • Using VB 2005 to insert record into Access 2000
    ... I created a console application in VB 2005, then chose data, add datasource, ... database, new connection. ... Save connection as: testConnectionstring ... Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM ...
    (microsoft.public.vb.general.discussion)
Quantcast