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?

__________________
A man's knowledge is like an expanding sphere, the surface corresponding to the boundary between the known and the unknown. As the sphere grows, so does its surface; the more a man learns, the more he realizes how much he does not know. Hence, the most ignorant man thinks he knows it all. - L. Sprague de Camp

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++.