rocky said:
hi,
we have a access database in atlanta and wish to connect
to a database in detroit for the purpose of extracting
data from detroit and write queries and download the
result to excel via microsoft query.
is this possible?
It is unlikely to be successful unless you have a very high-speed WAN
connection. Because of the nature of the Jet database engine, which is a
file-server, not a server, database, all the extraction and manipulation is
done on the user's machine.Thus an Internet or other modest-speed WAN
connection just is not sufficient.
To work with an Access (actually Jet) database, long-distance, over the
Internet you'll need to employ software to retrieve the data from the
database and transmit only the retrieved data across the Internet. Active
Server Pages (.asp or ASP.NET) are a powerful, flexible way; Microsoft Front
Page using the Database Interaction Wizard is a less-flexible, but simpler
approach; there are other, third-party, solutions. If you have control over
the software used on the client machines, you might investigate Access' own
Data Access Pages (DAP) -- they require the clients have Internet Explorer
5.5 or later, and the Office Web Extensions installed.
Larry Linson
Microsoft Access MVP
