Access and the Web

[Guest]

Can Access be setup where the source backend tables are from a web server?
If not, can I import the tables from the web server into Access and then visa
versa upload the tables back into the web server? If so, can you refer me to
an article that explains how to develop this process. thank you.

 

[Albert D. Kallal]

Well, are you considering to use this database "over" the internet....

I explain some possible solutions here:

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

it really depends on if you need ms-access to "use" those tables on that
server, and where that server is (eg: do you have to connect over the
internet to get to those tables).

In the case of back end mdb files, you can't connect to them over the
internet, but then again, most web services have a server based sql engine
that you can use anyway....

You can often find web servers (and services providers) that allow the web
site to connect to a mdb file that is on the web server. However, since you
not installing, nor actually use ms-access features on the web site..then
there is no advantages to using ms-access in these case for the data store
(might as well use the sql server options those web providers all offer --
and, ms-access can connect that data also).

So, you can most certainly have ms-access connect to the sql server (data)
on the web site, and you can further have ms-access even consume web
services if you desire.