copy tables .mdb1 tot .mdb2

[matrixindicator]

is there a way to copy with vba tables from the existing dbase to another mdb ?

 

[JerryKlmns]

Oh yes!

 

[PHV]

Have a look at the DoCmd.TransferDatabase method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixindicator]

ok, also other objects like forms and modules ?

 

[JerryKlmns]

If you are to copy many objects to a new database, would there be an option to copy the mdb file first and the delete the objects? I think it would be faster!

 

[PHV]

When in VBE press the F2 key, type transferdatabase in the search area, press Enter and finally F1.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixindicator]

Jerry,

You could not know it. This is not an option.
Because my dbase is large and trying to compact takes two days. When I simply copy the object to a new one the size reduced to 1/3.

 

[JerryKlmns]

My 378MB mdb file is compacted in ~4 min. How large is your mdb? Your 2 days compaction worries me dreadfully!

 

[matrixindicator]

Thanks for your possitive attention Jerry.