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.

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.

--
--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/...UBED1=ACCESS-L

<(E-Mail Removed)> wrote in message
news:ilnVd.33528$(E-Mail Removed)...
> 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.

(E-Mail Removed) wrote:
>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?


Check Help for the CreateDatabase and CopyObject methods.

--
Marsh
MVP [MS Access]

On Wed, 02 Mar 2005 18:11:30 GMT, (E-Mail Removed) wrote:

>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?

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

John W. Vinson[MVP]

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





In article <(E-Mail Removed)>,
(E-Mail Removed)group wrote:
>On Wed, 02 Mar 2005 18:11:30 GMT, (E-Mail Removed) wrote:
>
>>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?
>
>Yes; see the VBA help for the CreateDatabase method of the Application
>object.
>
> John W. Vinson[MVP]