what is the best way to update a field in a database on the internet?

[AccessGuruCarl]

Hello All,

From within access, I'd like to open a db on the internet, find a record based on the customer id, and update it with thier table version (a string value) and return true if it succeeded!

Is this possible from within access?

If not... Can I read/write cookies from access?
I would then simply create an asp page on the server to grab the value from the cookie.

Thanks in advance...

AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[Remou]

How about FTP from access to transfer the data file?

[tt]rv = Shell("FTP -n -s:""C:\Docs\updata.txt""", vbNormalFocus)[/tt]

Where updata.txt contains FTP commands:
[tt]OPEN ftp.thesite.com
USER
theusername
thepassword
CD thedir\path
BINARY
PROMPT N
PUT "C:\Docs\data.txt"
BYE[/tt]

I do not think you can set a cookie because they can only be read by the domain that sets them, from what I have read.

 

[JoeAtWork]

Perhaps you could implement a web service on the remote server?

But I don't know if you can invoke web services from within Access.

If this is an SQL server and they have allowed internet connections, this would be a simple stored procedure to update the value and return the result using ADO.