Link to home
Start Free TrialLog in
Avatar of Takamine334
Takamine334Flag for United States of America

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
Avatar of Anthony2000
Anthony2000
Flag of United States of America image

I found this link, it contains many examples that demonstrate creating an mdb database and creating a table within it.

http://functionx.com/ado/Lesson06.htm
ASKER CERTIFIED SOLUTION
Avatar of ravs120499
ravs120499

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
Avatar of Takamine334

ASKER

if I wanted ID to be an autonumber, what datatype would I use?
Avatar of ravs120499
ravs120499

Have you tried Autonumber as the type?
It's autoincrement