This article as a PDF. The

Accessing databases from different geographical locations

P: n/a

If you have some kind of Web application server running on Windows at your
ISP, and the database is on the same server, it will work because the Web
application is accessing the database locally, and the user is accessing the
Web page generated by the application.

The user's Web browser sees only ordinary html, and has no direct interaction
with the database, nor even need know whether such a thing exists.

Thanks, I realized that I needed to have the database open during my first
attempts at working with the FTP, but does that mean that Webpages also
won't work if the file is on an FTP server since it won't actually be
opening up the database? Or is it worth exploring that avenue to see if I
can access the data on the server from several remote locations?
"Steve Jorgensen" wrote in message
news:8sjd10hdhnoppmjsnijfhvtqg2vu48v1ra@4ax.com.. . FTP client software is set up to look and act like a filesystem from the
user interface point of view. It is not a filesystem, however. FTP is merely
a protocol for transferring files, but Access requires you to have the file
open for reading/writing at random positions in the file, lock portions of the
file, so other users know it's in use, etc. None of this is remotely
possible using FTP.

If you want a shared database accessible from the Internet, you either


need an actual filesystem connection such as you could get through RRAS (which
won't perform well at all), or you need a server database, such as MS SQL
Server, MySQL, or PstgreSQL. Most ISPs can at least offer you a MySQL instance
for a pretty low cost.
wrote: >Hi all,
I hope someone can help me. I've recently created a database and wantedto >put it up on an ftp sight so that multiple people could access the same
tables at the same time from different geographical locations. I havebeen >completely unsucessful in acheiving this goal so far however.
Things I have tried:
Create a shortcut to ftp sight via browser then tried to map local driveto >remote folder. - Won't work, when I get to the mapping screen and Iselect >the folder it won't let the "OK" button become useable.
Created a page from within Access to pull just a tables worth on
information. I then uploaded the page to the FTP sight and triedaccessing >it that way but the local computer says that the safety settings on this
computer prohibit accessing a data source on another domain. I've tried
added that sight to trusted sights, disabling all firewalls and still I'm
unable to get the page to show up.
Can anyone please offer me any suggestions on something to try? I'm just
trying to access data from a central database. Not very different from
replication really except that I'm trying to do it on the web.
You might also like
What is GIS? Video produced by ESRI
What is GIS? Video produced by ESRI
Geographic information system (English version)
Geographic information system (English version)
Matric revision: Geography: What is a Geographical
Matric revision: Geography: What is a Geographical ...

I am not lying

Unk I never claimed to be in the < JeepFuckedAgain > 2013-07-09 06:25:07
security business honey.... I have a security clearance and work in the GIS and CRM field....get your shit straight about me will you
unk Nah. He is a contractor < - > 2013-07-09 06:21:42
working in a small business doing GIS grunt work for the Fed. If they knew what he was up to in real life, he'd be in prison STAT!
unk then you're an idiot.... < JeepFuckedAgain > 2013-07-03 08:18:13
GIS...geographical information systems.... and I take care of historical issues pertaining to the agencies buildings and land....

Esri Press What Is ArcGIS 9.2?
Book (Esri Press)
  • Used Book in Good Condition

Ligonier Borough complies with directional sign mandate  — Tribune-Review
Although Geographic Information Systems mapping of the borough pinpoints all directional signs, it does not include all data needed to comply with the program. “They want to see off-sets, heights, directions, locations, all kinds of stuff,” Faas said.

Wiley Business Site Selection, Location Analysis and GIS
Book (Wiley)
CRC Press GIS Cartography: A Guide to Effective Map Design
Book (CRC Press)
  • Used Book in Good Condition
SAGE Publications Ltd Quantitative Geography: Perspectives on Spatial Data Analysis
Book (SAGE Publications Ltd)
  • Used Book in Good Condition
Wiley Terrain Analysis: Principles and Applications
Book (Wiley)

Popular Q&A

avatar
What virtualized folders enable users to access files from different locations as if they were all in the same place

Virtual folders

Related Posts