Hi all pro,
Can you teach me how to using vb coding to ask the access file's database save up another copy for backup???
Waiting for you advice...

Than you.

hi there.. access by itself can't copy the database (but you can do a compact via Jet to do that, and that will make a copy)..

anyway, the easy way is to close the connection and just copy the file to your new destination...

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

hi there,
Sorry...I didn't get your means.Could you give some example or coding to let me more understand it.What is the compact via Jet ???
Waiting for your advice...

Thank you.

Compact is the way to recover unused space for an access database.. using the dbengine you can do it inside Vb.. I can't give you any code since it's different for DAO and ADO, and if you want to carry with this option you can find a lot over google. If you don't want to use this technique (if the database is big it could take some time), just close all the connections to it and do a copyfile...

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

Hi there,
Then what is the "dbengine" and where could I found it???
Waiting for you advices...

Thank you.

Dbengine is an object inside vb6... you could find that kind of info in google...

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

I don't understand what are you asking.. if this is a different question please post it in a new topic with a title related to it...

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

Whazzamadder Gonzo? Not enough verbs? Nouns?
There are more than enough to choose from, don't ya think?
Mix–N–match verbs, nouns, predicates. (More than enough ?’s too!)

Hi pro,
Sorry,I know how to do already for the new question.But the old question which related to topic ones still not solve yet.Could you please give me some web address to let me know it more detail.
Waiting for your advice...

Thank you.

Lol Brian... ;)

As I told you before, DBengine is an object inside VB 6.. you could find a lot of info about in the MSDN or in google...

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