DAO and SQL Server

I want to create a new database on a SQL Server using DAO.
Is it possible and if so, Does anyone have any example how to do so?
Thanks,Possible: Yes

Examples: No

Advice: Don't do it.|||he he
I don't have much choice. We are running DAO here in my office and then don't want to ship ADO.

How would I go about doing it?

How would I connect to the server?

I can then run the Create Database SQL command, correct?

Thanks,|||Oh yeah, I don't want to use ODBC.|||Is this MSDE and not SQL Server?

If it's SQL Server, don't you have SQL Server client tools?|||Yes it is MSDE.

I have to do it all programmatically.

The point for this application will be to take an existing Access database and convert it to MSDE and then transfer all the data.

I have to do it programmatically due to the following reasons:
over 600 clients
clients have different versions of the application
only DAO is distributed.|||Originally posted by vbgladiator
Yes it is MSDE.

I have to do it all programmatically.

The point for this application will be to take an existing Access database and convert it to MSDE and then transfer all the data.

I have to do it programmatically due to the following reasons:
over 600 clients
clients have different versions of the application
only DAO is distributed.

Let's all bow or heads in a moment of silence...|||he he he
thank you, thank you.

he heh e

I know, this is a pain.
I had it in ADO but I don't even know how to connect to SQL server using DAO.|||Check out the link in this thread...

it's a link to some shareware that you might find useful...

http://www.dbforums.com/t972789.html

(would help if I paste it here, wouldn't it)|||What thread?