[RESOLVED] Create an Access DB from vb6 code

[longwolf]

I'm working with VB6 and Access DB's
Up till now, I've been making my DB's with MS Access and then writing VB programs to work with them.
But my latest project needs the ability to export/import data to/from a DB so that different users of my app can share updates.
The exporter will get to choose which tables and filters to use.

Can someone point me to a tutorial, code or just explain how to...
1. Create the DB
2. Add tables
3. Add fields to the table
4. Set the Field Size/Data types (One table holds pictures using Rhinobull's code)

P.S. I'd like to avoid adding any new references to the project, but I'm flexible.
It currently has:
OLE Automation
Microsoft ActiveX Data Objects 2.8 Library
Microsoft ADO Ext. 2.8 for DDL and security
Microsoft Jet and Replication Objects 2.6 Library

[longwolf]

Never mind.
I found an ADOCodeGen on PSC: http://www.planet-source-code.com/vb...30788&lngWId=1

You point it a mdb and it makes the code to recreate the mdb.

I think i can figure out what I need from the code it's made.

I'll leave the thread open until I'm sure I've got it working.