howto : create database other then access from vb

[ldblaauw]

Hi,

I need to be able from my program to create
all sorts of databases from scratch, like
sql server. I know it is easy to do an access
database, but i am wondering how to initialize other database ?

Any help appreciated.

Greetings,
Leo de Blaauw

[SmithVoice]

Well, if you want to create ISAM format "databases" (better called ISAM Datasources) then MS says you can not do it (page 314 of the Jet3 Blue manual, page 375 of the Jet3.5 white manual)

However, MS is not really telling the truth here. If Access can create dBase/FoxPro, Paradox, CSVText, HTMLTable, Lotus123 and Excel files then it means that Jet can do it, after all Access is just a front end for Jet.

SQLServer, Oracle and other non-ISAMs aside, you might find a lot of power in the source code examples at:
http://www.smithvoice.com/vbda.htm

and the other details at:
http://www.smithvoice.com/vb5expt.htm

-Robert Smith