Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

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?
0
bmatumbura
Asked:
bmatumbura
  • 2
1 Solution
 
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
 
fvaCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now