asked on

How can i upload 5 mb mdb file to my web server?

How can i upload mydb.mdb file to web server everytime user click on upload from there client vb application. i want to create same mdb file on server when user upload then mdb file. how can i do this so the upload time will me the minimum.

Hint: how about if i convert all of the table into text file and upload the text file then on my webserver i can convert back to mdb file or somehow generate mdb file from text file. Is it possible? Or is there any better solution?
I just want to minimize the upload time.
In future On webserver i may went to store all information into sql sever if needed.
Now i'm using access2000. Is access2002 will be helpful in this kind of upload transaction?

Any help or hint will be apriciated.

rspahitz

If you want to minimize the upload time, simply upload the parts that you want changed, then have a serverside process that handles the updates to the DB.

ASKER CERTIFIED SOLUTION

Richie_Simonetti

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bcp5190

ASKER

can you provide some code i'll increase my point.

Richie_Simonetti

Me?

Anthony Perkins

Just a reminder that you have several open questions. Please maintain them before proceeding:

http://devx.experts-exchange.com/jsp/memberProfile.jsp?mbr=bcp5190&showQHistory=true

Questions Asked 76
Last 10 Grades Given A B A A A A A A A A
Question Grading Record 52 Answers Graded / 57 Answers Received

Thanks,
Anthony

bcp5190

ASKER

i have answered some of the questions, thanks

Richie_Simonetti

Well, do you need my example?

Netminder

bcp5190

ASKER

Thanks for an idea but can you please give me some examples
Thanks

Richie_Simonetti

Yes. You need to send text files with SQL inside it and store them in a specific folder. After that, you need to read each file, create a querydef(DAO) or a Command (ADO) that executes it and is almost done.