Creating a database at runtime

I need code/class/ActiveX that I can use to create a database (files, table, fields, ...) at runtime. I need to create Microsoft JET databases using DAO/ADO at runtime. Is there any web site that has some free sapmles I can use?
LVL 11
bmatumburaAsked:
Who is Participating?
 
fvaConnect With a Mentor Commented:
This will depend on the particular engine used. I guess that some will have a "default" directory specified in the connection phase, others might accept the full file name in the CREATE statement, but eventually fully quoted (like CREATE TABLE "C:\MYDATA\EMP.DBF" (...) )

I'm not really into DAO/ADO and you might want to seek additional advice. Please treat my suggestions with caution.

F.
0
 
fvaCommented:
Try to use SQL syntax ("CREATE TABLE..."/"ALTER TABLE ...") in whatever engine you are working with (it should support SQL, but that's true for most of them).

HTH,
F.
0
 
bmatumburaAuthor Commented:
fva

How do I create the database files themselves? I need to to store them in a known folder.
0
All Courses

From novice to tech pro — start learning today.