Access Connection

[Wayne]

Hi,

If I have several users in different cities, such as Hong Kong, Beijing, New York and the main database is saved in London. How do the users can input the data to the access file in London.
Shall I save the database in SQL sever? but How can the clients in different cities connect to the SQL sever?
Thank you very much!

Wayne

 

[Arvin Meyer]

Hi,

If I have several users in different cities, such as Hong Kong, Beijing,
New York and the main database is saved in London. How do the users can
input the data to the access file in London.
Shall I save the database in SQL sever? but How can the clients in
different cities connect to the SQL sever?
Thank you very much!

The 2 best (but most expensive) solutions:

1. ASP pages connected to the Access database. (or ColdFusion pages)
2. A Terminal server.

Of the 2, I prefer the terminal server as there are fewer things to go
wrong.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access