Solved

Creating a database at runtime

Posted on 2001-06-25
3
140 Views
Last Modified: 2010-04-06
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
Comment
Question by:bmatumbura
  • 2
3 Comments
 
LVL 4

Expert Comment

by:fva
ID: 6226935
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
 
LVL 11

Author Comment

by:bmatumbura
ID: 6230560
fva

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

Accepted Solution

by:
fva earned 50 total points
ID: 6230584
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

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question