Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating SQL Query by CDaoDatabase::Execute function !

Status
Not open for further replies.

HadiRezaee

Technical User
Mar 9, 2001
165
IR
Hi all,

How can i create a SQL Query in Access Database (.mdb), by CDaoDatabase::Execute ????

Help me :(

 
What exactly is your problem?

If you have an open connection, this should work

MyDB.Execute("CREATE TABLE AAA (ProductName Text, ProductDate Date)");
MyDB.Close();

Your not trying to run a select query with Execute are you? That won't work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top