Carl

I've got Visual Studio .NET 2003 and I'm exploring VB at the moment. I haven't used VB since version 4 so you can imagine the uphill struggle I'm facing.

I'm used to using the DAO for data access but now have to use ADO. I've worked out how to open an Access database, but how on earth can I create one in code? Do I have to use SQL as most of the code snippets I've found on the Internet or is there another way?

It's not for a project specifically, just something that I'd like to know how to do.

Carl

__________________
Software developer since 1982, started on a ZX81.
Been developing in Delphi since 1998.
Currently trying to get my head round C++.

lectricpharaoh

I believe so. However, I don't believe you can (easily) create the database. However, you can add tables to it, so you could start with an empty database, and essentially build it in code. I think you'd be stuck with SQL, but why is that a problem?

__________________
And once again, Probability proves itself willing to sneak into a back alley and service Drama as would a copper-piece harlot.
- Vaarsuvius, Order of the Stick

Carl

It's not really a problem, I just wondered if there was another way to do it. I've been doing a few google searches on DAO to ADO conversion. I tried opening a VB4 project in to 2003, but it said that the project is not a valid VB6 project. Guess I can't do from 4 to 7 easily.

Oh well, onwards and upwards

Carl

__________________
Software developer since 1982, started on a ZX81.
Been developing in Delphi since 1998.
Currently trying to get my head round C++.