Access Application Development

[Guest]

I am planning to develop a Access Application (EPOS), (Stock Control) and
(Client Management).
The application will be used at 4 sites. They will comunicate via a VPN.
Would this work, also the data will be on SQL server.

please advise.

 

[Wayne Morgan]

While using SQL Server will improve this, the SQL Server will limit the data
before it is sent across the VPN if you only pull data from queries, views,
etc., I still wouldn't recommend it. It would be better to place all of the
work on the server using IIS (ASP) to access the data. This way only the
display of the data will be sent across the VPN.

 

[Tony Toews]

While using SQL Server will improve this, the SQL Server will limit the data
before it is sent across the VPN if you only pull data from queries, views,
etc., I still wouldn't recommend it.

I dunno about that. Tom Ellison has mentioned that SQL Server is
quite good in this respect. He has also used Access over a dialup
connection to SQL Server. Not great but it worked.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm