Solved

database acces with vb 6.0

Posted on 2000-04-10
3
151 Views
Last Modified: 2010-05-02
on a form, Insert, modify and delete a record on a dbf table with ADODC ( i will apreciate to receive the code to know how to do it!!)
0
Comment
Question by:poirier_i
3 Comments
 

Author Comment

by:poirier_i
ID: 2701510
Adjusted points from 15 to 50
0
 
LVL 9

Expert Comment

by:samopal
ID: 2701725
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset

cn.Open "DSN=Visual FoxPro Tables;UID=;PWD=;SourceDB=d:\My Work;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
rs.Open "select * from test", cn

' Add new record
rs.addnew
rs.fields(0)=122
rs.fields(1)="xxx"
rs.update

'Edit record
rs.fields(0)=133
rs.update

'Delete record
rs.delete
rs.update

PS Test.dbf is a table in d:/My Work directory

HTH
0
 

Accepted Solution

by:
gfaucher earned 50 total points
ID: 2703533
it might be this kind of code. if your ADODC is on the form.

'to insert
adodc.recordset.addnew
adodc.recordset.field(0) = String 'or
adodc.recordset.field("Fieldname") = string
adodc.recordset.update

'to edit
adodc.recorset.field(0) = string
adodc.recordset.update

'to delete
adodc.recordset.delete
adodc.update

and if you want your modification to be visible put adodc.refresh after your update
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Specify ip address in my connection string for sas 2 54
SSRS expression Issue finding a string 10 66
Copy a row 12 59
Protecting vb6 & .Net code Obfuscation 18 97
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now