Link to home
Start Free TrialLog in
Avatar of undyshelts
undyshelts

asked on

DAO Query Troubles in VB.NET

Hey everyone,

I'm using VB.NET and DAO here.

I've got an access database with some tables and queries.

I can connect to the database fine and retrieve records from tables using "SELECT....."

My 1st question:
Is it possible to execute a query that is in the access database from DAO in VB.NET..

My 2nd Question:
What's the DAO VB.NET syntax to delete all records in a table using the sql "DELETE * FROM table_name".

Cheers :-)
Avatar of undyshelts
undyshelts

ASKER

IT'S OK EVERYONE... I FIGURED IT OUT MYSELF!!!
SORRY :-)!!!

it's the .execute(sql_statment) command :-)
Avatar of Dirk Haest
Question: why do you use DAO in VB.NET and not the new version of ADO.NET ???
ASKER CERTIFIED SOLUTION
Avatar of PashaMod
PashaMod

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial