submit records from client machine to web

[nivini]

Hi all
I tried in asp forum, but gain nothing. hope for better results..
I need to export/upload records from my machine to my webserver.(on the net, not my local)
I have a vb app, i wrote a while ago, and it has mdb file, holding all the information, now i need this information (records) to be submitted to web server.
Normally u create an asp/html page, on the net, fill it with the information (the records) in the appropriate fields and submit it to the server, where it proccesses for farther use. But i have some 6000 records to be submitted, can i outomate it from my vb app??
I hope i made an understandable question
many TIA
nivini

 

[comaboy]

This probably won't help and I'm assuming you have Access, but: Do you really need to upload all of your records?

If you have FTP/Frontpage access to your site, you could simply download the MDB, update and re-upload.

Depending on your version of access you may be able to open the Web database remotely and just update it directly with a Copy/Paste.

If your server permits it, you could also use ADODB from VB...

There are, basically, a number of methods you could use! It all depends on how/why you need to update. ie, for a weekly automated update you'd want to scedule VB... for a one-hit job you'd (I'd) use Access.

Also if the Webserver is also a SQL Server, yet more options open up!

Can you give us a bit more detail about what you're hoping to do?

All the best,

Coma

 

[nivini]

Thanks Coma for your replay.
I wrote the vb app for a client who 'needs one button to press', and the job is done. So asking her to upload the mdb through ftp or even the the upload operation which the web server supplier enable is out of a question. not to mention she might upload it to the wrong folder. So,
the first time to upload, will be of a 6000 records, but later on, in normal use there will be a weekly updating of 10 to 20 records. these records are updated in the vb app
in realtime, the web server is tobe updated once a week.
I cant ask my client to enter the records details again, once she entered it to her mdb, it should be used for the web updating too.
<If your server permits it, you could also use ADODB from VB... >
what will be the code for that?

<Depending on your version of access you may be able to open the Web database remotely and just update it directly with a Copy/Paste.>

I also wrote the asp pages for the client web, but i can't
deliver/upload/export the records from the client machine (mine for this matter) to the web mdb
which will be the way?

 

[comaboy]

OK, I'm assuming you have an SQL Server. First off read these two articles.

http://msdn.microsoft.com/library/d...-us/vbcon98/html/vbconusingadodatacontrol.asp

http://msdn.microsoft.com/library/d...bcon98/html/vbconusingremotedatacontrolpg.asp

Then add a Refernece to ADO and play about with the following code:

Dim ADOConn
Dim rs

Set ADOConn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")

ADOConn.Open "DSN=mysqlserv;uid=remote;pwd=mypass01;"
'DSN = Server Name
'Uid = User Id with rights for external update
'pwd = password (Make it STRONG!)
Set rs = ADOConn.Execute("Select * from tblTableOnTheServer") ' run the sequel statement. Can be Update, etc

Finally close and lose the objects
rs.close
set rs=nothing
ADOConn.Close
Set ADOConn = Nothing

It's not even brief introduction on ADODB - but It might help you get started!

Oh, and if your server is behind a firewall, you'll have to open/forward some ports!

 

[comaboy]

Also a method I onced use for exactly this sort of situation is to have my client automatically email the records to remoteserver@myaddress.co.uk

There was a program on the server that checks for mail every 10 minutes. If a "data mail" comes in, it iterated through the records and updated as necessary. NOTE: Don't even consider this if you are sending confidential/sensitive data!

Just a thought !

 

[nivini]

Thanks a bunch, I'll try it all
again many thanks
nivini