Solved

Creating a database at runtime

Posted on 2001-06-25
3
138 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now