Takamine334
asked on
Create New Table in MDB database
How do I create a table in a database from scratch using ADO code? I just want to have an inputbox with NewUSERDB as the string variable. That person will input a table name (ex. Portland, OR) and it'll create a table in a database (MDB) with the fields:
ID
Name
Age
Sex
City
State
Country
Birthday
Picture
Music
Last Login
ID
Name
Age
Sex
City
State
Country
Birthday
Picture
Music
Last Login
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
if I wanted ID to be an autonumber, what datatype would I use?
Have you tried Autonumber as the type?
ASKER
It's autoincrement
http://functionx.com/ado/Lesson06.htm