Re: Connection string for an access file on a remote server

Hi,

actually I don't know if this is possible with Access to have your application
on your network and the access the file on a server that's not in your network
(another hosting company). 

You can take a look at the possible connectionstrings here:
http://www.connectionstrings.com/?carrier=access2007 or
http://www.connectionstrings.com/?carrier=access.

Grz, Kris.

XIII:




actually I don't know if this is possible with Access to have your application
on your network and the access the file on a server that's not in your network
(another hosting company). 



Yes it is possible, but setup is not straightforward (and pretty unlikely to be
agreed to by the other hosting company), and performance can be problematic.
http://databases.aspfaq.com/database/why-can-t-i-access-a-database-or-text-file-
on-another-server.html

To TK:

Ideally you would use Sql Server for this, but an alternative workaround is to
set up a web service on the server hosting the db, and use that, or you can kind
of kludge it by using httpwebrequest to call pages on the remote server that
will query the database and output the results which can be collected by
httpwebresponse and parsed for the data.