I found this code for creating a table at codehound. (actually vb world in a series of articles by John Percival)
Dim mydb As Database
Set mydb = createdatabase("C:mydb.mdn", dblandgeneral)
mysqlstring = "Create table thistable (firstname text,lastname text);"
mydb.execute mysqlstring
mydb.Close
The code give a..... user defined type not defined... error on the dim mydb as database line. Any suggestions?
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw