TransferDatabase

[Owen Jenkins]

My FE/BE database occasionally needs to create a new database containing
tables from two other databases. At present, using code in the FE, I
create a new db on the server, import the objects into the current
database (on the local PC) then export them to the new db. This tends to
be slow over the network and bloats the front end. Is there a better
way? I'm using DoCmd.TransferD atabase to do the importing and exporting.

Owen Jenkins

[paii, Ron]

Re: TransferDatabas e


"Owen Jenkins" <oj@healthbase. com.auwrote in message
news:1186464500 .533509@mx2.pip .com.au...

My FE/BE database occasionally needs to create a new database containing
tables from two other databases. At present, using code in the FE, I
create a new db on the server, import the objects into the current
database (on the local PC) then export them to the new db. This tends to
be slow over the network and bloats the front end. Is there a better
way? I'm using DoCmd.TransferD atabase to do the importing and exporting.
>
Owen Jenkins

Using VBA you can open 2 or more databases under a single workspace. This
should allow you to transfer the data without bloating the front end.