Thanks Edwin!
for your quick reply and great tips!

The situation is very bad so not likely to push towards an online situation. Offline mode is a must!

about web server -- i tried Abyss Web Server.
its good one for database server...
BUT SHOULD I KEEP CLIENT SIDE software app with local database running on that?
(will it give issues like 404-not found or some thing ...i am worried because client side is not tech savvy ....and its not possible to support so many users for silly things like webserver not running etc.)
(OR should it be a standalone app in VB6 or so?)

You did say "For synchronizing you could use a webservice, not so hard to do."
Can you please explain or give some references please.
also is it possible in other platforms like PHP etc?

is there any "third party" software to do that? synchronizing thing directly from database?

i actually need to do it fast as well..

Thanks again for your kind support