ADO Question

OK, I've heard DAO is being phased out... So I want to use ADO for my next project. But I'm new to ADO (have done a lot of projects with DAO and are experienced enough...) and am encountering a few problems...

Problems:

• I don't know how to create an NON-existing database IN CODE for ADO. I knew how to do it with DAO though. Just obj.createdatabase(blahblah) and there was a database. I used the DAO3.61 reference in my project for that. I think I have to use "Microsoft ActiveX Data-Objects 2.5 library" now. How do I do it IN CODE. I don't want to use some objects or third-party OCX's
• I know ADO can also handle my SQL queries, I know how to create recordsets etc... I Don't want to have to distribute some sort of SQL-server with my app, I want it to be "stand alone" (ofcourse the run-time files etc.. will be distributed). (Reason for that is that distributing some extra software like MySQL or MS-SQL 7 or so will require additional support, and alse the cost will be higher if it would be a commercial product.) Will it handle some multi-user environment, and will I be able to put the database on a shared drive/folder on a server OR workstation? (I don't want to have to sell a server for clients that don't have a server and only have 1 or 2 workstations.)
• How long will ADO last (stupid question?)
• I want the database to be Access 2000 Compatible, just as my DAO databases are now... Can it?
• Oh... And would I be able to connect Crystal reports 8 to it?

Any help, or a pointer to a "beginners tutorial for ADO" would be appreciated.

Thanx in advance...

[Edited by RobIII on 09-25-2000 at 05:56 AM]

As far as I know, ADO can't create databases or tables in the same way that DAO could. But, ADOX is an ADO extension that may have what you're looking for.

Add a reference "Microsoft ADO Ext. for DDL and Security." to your project and this gives you something similar to what you're used to in DAO.

I haven't used it myself so I can't tell you how to use it.

Simon.