By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 2,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

Deleting Records

Ali Rizwan
100+
P: 927
Hi
I want to delete a record from a database.
I m using vb6 and msaccess and os is xp.
thanxx
Sep 11 '07 #1
Share this Question
Share on Google+
3 Replies


VBPhilly
P: 95
Hi
I want to delete a record from a database.
I m using vb6 and msaccess and os is xp.
thanxx
Your missing one thing: data access strategy.

This can be DAO (data access objects) or ADO (ActiveX Data Objects). You can also use controls in VB (ADO Data Control) or the Data Environment object.

If you like to code, use DAO or ADO.
Otherwise, use the Data Control or Data Environment.

Personally, i'de use ADO to open the Access database. More control.
Its up to you. Good luck.
Sep 11 '07 #2

Ali Rizwan
100+
P: 927
Your missing one thing: data access strategy.

This can be DAO (data access objects) or ADO (ActiveX Data Objects). You can also use controls in VB (ADO Data Control) or the Data Environment object.

If you like to code, use DAO or ADO.
Otherwise, use the Data Control or Data Environment.

Personally, i'de use ADO to open the Access database. More control.
Its up to you. Good luck.
Thanx
I m using ado and want to delete a record using ado not data environment.
Sep 13 '07 #3

VBPhilly
P: 95
Thanx
I m using ado and want to delete a record using ado not data environment.
learn SQL and use a DELETE statement to delete the record you need.

send the SQL command to the ADODB.Connection object using Execute.
Sep 13 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.