Accessing a remote server from MS Access

[Guest]

I want to link a front-end written in MS Access 2002 to a database on a
remote server on the web so that it can receive data from remote clients.
What are my options and how do I learn about doing it?

 

[Albert D. Kallal]

Here is some options:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

 

[punjab_tom]

use Access Data Projects; and keep your DATA in a DATABASE

I mean; MDB is only used by queers

 

[punjab_tom]

in other words:

MDB doesn't work across a WAN
MDB doesn't work across a VPN
MDB doesn't work across a PUBLIC ****ING INTERNET
MDB doesn't work across a WIRELESS



and I'll bet you didn't see this coming
ACCESS DATA PROJECTS WORKS FLAWLESSLY _EVERYWHERE_

 

[Guest]

I should have made our situation clearer. Our app already uses an Access
front-end and an SQL Server back-end on our customers own machines. If they
install it as a single user system they are both on the same machine, or they
can install the back-end on their own server. We also make use of
replication so that they can take copies out of the office. That is all
working well.

What we now want to do is have our customers machines communicate with ours
accross the internet when they first start using the product so that we know
who they are and where they are, so that we can send them an Activation ID.
We also occasionally want our customers systems to download price files from
our own webserver.

I have been considering using Office Web Components or XML. Any comments
anyone?

 

[Brendan Reynolds]

If you can implement the feature on the server as a web service, the Office
2003 Web Services Toolkit makes it easy to call a web service from Access
2003. There is an Office XP Web Services Toolkit too, if you're using Access
2002. And the 2003 toolkit appears to work with Access 2007 as well. Both
toolkits are available as free downloads from Microsoft's download site.

A new option in Access 2007 is the ability to create managed code (.NET)
add-ins to wrap the calls to the web service, but this is something that I
haven't looked into in any detail as yet.