Feb 2, 2002 #1 HadiRezaee Technical User Joined Mar 9, 2001 Messages 165 Location IR Hi all, How can i create a SQL Query in Access Database (.mdb), by CDaoDatabase::Execute ???? Help me
Hi all, How can i create a SQL Query in Access Database (.mdb), by CDaoDatabase::Execute ???? Help me
Feb 2, 2002 #2 MinnisotaFreezing Programmer Joined Jun 21, 2001 Messages 120 Location KR 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. Upvote 0 Downvote
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.