Access Database help!

Ok, I want to be able to create a new microsoft access database, and create tables inside that database, from inside the program I am making . You know like not have to physicly go into microsoft access and make the database, then the table, the fields of the table etc. Right now I am using DAO, but I cannot figure out how to do it with that. ANY SUGGESTIONS! If someone could just point me in the right direction I can more than likely make it from there. Thanks!(first time posting on the site by the way)

I use ADO from code.

http://msdn.microsoft.com/library/e.../mdaprogref.asp

It looks liks ADO has exaxtly what DAO has. I cannot find anything in the documentation about doing what I mentioned in my first post.Is it even possible?!

I don't have any samples. Take a look at the ADOX documentation, I believe that allows you to create a new .mdb from code.

Or you could keep a blank .mdb as a template and copy it to create your new .mdb, then use the standard CREATE TABLE sql ddl commands to create your structure.

I've never done this before, so let me ask if it's possible. If you have Access installed, can you make a reference to the Access type library and use it to create a new access object and a new database?

I am not sure about that one. I would perfer the user not need to have access installed to run the program. Perhaps there is another way to store the data I need without using access. MySQL has SQL statements to create a db, table, and properties in that table right? Would running a local MySQL server be the trick? I think I just answered my own question... anyone?

I would say so, since if the user doesn't have Access - I don't know how they would create an Access db anyway

This, sounds like it will be a bitch.

how complex is the data?... and how much data is it?

As I posted above, look at ADOX

http://msdn.microsoft.com/library/e.../adoddlx1_8.asp