Not without MAGIC, but, that's not what you need to hear. Why CLEAR a DB that doesn't exist, then write another one? If you have one, you can upload it to a site that has MySQL, and access it from your VB6 program.
Find a webhost that provides a DB Server for your use. (Most do)
The application in the laptop could use any database (Access, Mysql, SQL, etc.)
Use the one you like more
Do not search for mysql, search for VB6 & ADO instead
That's the tool you'll need to develop the local application
And about the 'updating part'... it could be an option in your application
You could connect directly to the website database or you could send the day's transactions and develop a small application in the server side... etc.
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...