How can i copy an access database and then rename it in vb 6.0.
Any one with sol. It's urgent.

Hi,

Try this

DBengine.CompactDatabase [sourcedatabasename],[newdatabasename]
ie:
Dbengine.Compactdatabase "c:\myolddatabase.mdb","d:\mynewdatabase.mdb"

You need to make a reference to DAO 3.51 or 3.6, but you probably have it already.

Best regards,:)
Finn

thanx Finn for ur prompt responseit worked perfectly

I am new to all of this and would like to know how and where this code can be applied.

Thanks....

Rt

what do you mean with that question. I realized you are new, but what are you looking for???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========