Create Access MDB file from ADO Recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emma - 25 Apr 2006 18:09 GMT

How can I create an Access MDB database file from within VB6 using the
results of multiple ADO recordsets to add tables to the file? The records are
coming from a SQL database.

Thanks
Emma

Reply to this Message

Ralph - 25 Apr 2006 21:14 GMT

> How can I create an Access MDB database file from within VB6 using the
> results of multiple ADO recordsets to add tables to the file? The records are
> coming from a SQL database.
>
> Thanks
> Emma

Don't know how to do it from ADO, but this works using DAO.
http://www.zen51342.zen.co.uk/vbadv/vbadv_076.htm
Then you have to configure it. ADOX is likely the easiest library for that.

You might consider just creating a blank .mdb and copying it whenever you
need a new one.

-ralph

Reply to this Message

Veign - 25 Apr 2006 21:55 GMT

Some sample on this page:
http://www.veign.com/vrc_app_cat.asp?catid=9

Signature

Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
Veign's Blog
http://www.veign.com/blog
--

>> How can I create an Access MDB database file from within VB6 using the
>> results of multiple ADO recordsets to add tables to the file? The records
[quoted text clipped - 13 lines]
>
> -ralph

Reply to this Message

Ralph - 26 Apr 2006 01:23 GMT

> Some sample on this page:
> http://www.veign.com/vrc_app_cat.asp?catid=9
[quoted text clipped - 16 lines]
> >
> > -ralph

LOL

All these years of using ADOX and I never tried to create a new database...

Always learn'n somethumptn.

-ralph

Reply to this Message

Veign - 26 Apr 2006 01:35 GMT

ADOX can do a lot. Also can do a lot without the burden of ADOX, but
creating a database is not one of them...

Signature

Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
Veign's Blog
http://www.veign.com/blog
--

>> Some sample on this page:
>> http://www.veign.com/vrc_app_cat.asp?catid=9
[quoted text clipped - 27 lines]
>
> -ralph

Reply to this Message

Emma - 26 Apr 2006 14:44 GMT

Thank you very much. This is exactly what I was looking for.

> Some sample on this page:
> http://www.veign.com/vrc_app_cat.asp?catid=9
[quoted text clipped - 16 lines]
> >
> > -ralph

Reply to this Message

VB Forum / Database Access / April 2006

Create Access MDB file from ADO Recordset