Programming Forums - View Single Post - Creating an Access Database programmatically...

Carl · Jun 3rd, 2006, 3:33 PM

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

Jun 3rd, 2006, 3:33 PM	#1
Carl Newbie Join Date: Sep 2004 Location: Chelmsford, Essex, UK Posts: 28 Rep Power: 0	Creating an Access Database programmatically... 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++.