Ok, I'll try that. Thanks for your help.
Seth
> Personally, I prefer not to create the database itself. To do requires
that
you load additional DDLs that manage the data definition language
components
of the JET database. What I prefer to do is to keep an entirely empty
copy
of a JET database, then copy it to a name I really want to use; then, use
straight forward SQL to populate it.
This is admittedly less powerful than employing the JET specific DLLs that
manage the JET database, but it is simple. However, you prefer to use the
native drivers for JET, you should be able to find documentation for
creation of a new JET database by looking for the DAO object in one of the
MSDN libraries. Just remember that DAO is a COM object....
For MSDN or MS SQL, you can create a new database and then restore the
content from database backup -- all by issuing tSQL script.
----- Original Message -----
From: "Seth Bembeneck" <sbembeneck@c...>
To: "pro_VB_dotnet" <pro_vb_dotnet@p...>
Sent: Wednesday, May 01, 2002 12:11 PM
Subject: [pro_vb_dotnet] Re: Database
> How would I create the Access database during runtime?
> Seth
> > Do mean to say you have no admin priveleges? If so, you need to
> arrange to
> have permission to add a database to MS SQL server (even MSDE). Then
use
> TSQL commands to manipulate the MS SQL server to attach a database or to
> create a database.
>
> If you mean you need to use the JET database used by Access, then all
you
> do
> is create the file itself. You can start up with an empty database if
you
> like too.
>
>
>
> ----- Original Message -----
> From: "Seth Bembeneck" <sbembeneck@c...>
> To: "pro_VB_dotnet" <pro_vb_dotnet@p...>
> Sent: Monday, April 29, 2002 3:33 PM
> Subject: [pro_vb_dotnet] Database
>
>
> > How do I go about creating a database? I need to be able to do it
during
> > run time and I don't have access to a SQL server. Thanks,
> > Seth
> > ---
> > Change your mail options at http://p2p.wrox.com/manager.asp or
> > to unsubscribe send a blank email to
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or
> to unsubscribe send a blank email to