Create a new database with VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

felixc36@yahoo.com - 02 Mar 2005 18:11 GMT

Hi,

I have an Access 97 database and at the end of a process I want to export some
tables to new database.

What I want to do is first create a new database and then copy some tables to
this new database.

When i tried to export a table with the transferdatabase method i got an error
message since the database is not existant at the time of the transfer. So I
presume I must create a database first. Then copy the tables and queries
after.

Is this possible with Access 97?

Thank tou in advance.

Felix.

Reply to this Message

Roger Carlson - 02 Mar 2005 19:47 GMT

Sure. On my website (www.rogersaccesslibrary.com) is a small sample
database called "ImportToTempDatabase.mdb" which illustrates how to do this
for importing data without causing database bloat. It should easily
transfer to your situation.

Signature

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> Hi,
>
[quoted text clipped - 14 lines]
>
> Felix.

Reply to this Message

Marshall Barton - 02 Mar 2005 19:58 GMT

>I have an Access 97 database and at the end of a process I want to export some
>tables to new database.
[quoted text clipped - 8 lines]
>
>Is this possible with Access 97?

Check Help for the CreateDatabase and CopyObject methods.

Signature

Marsh
MVP [MS Access]

Reply to this Message

John Vinson - 02 Mar 2005 20:04 GMT

>Hi,
>
[quoted text clipped - 10 lines]
>
>Is this possible with Access 97?

Yes; see the VBA help for the CreateDatabase method of the Application
object.

John W. Vinson[MVP]

Reply to this Message

felixc36@yahoo.com - 05 Mar 2005 22:38 GMT

Thanks everyone.... with the create database method it worked fine.

>>Hi,
>>
[quoted text clipped - 17 lines]
>
> John W. Vinson[MVP]

Reply to this Message