csgraham74 (cs********@gmail.com) writes:
Thanks for the response on this. Can they link to SQL SERVER 2005 that
would be hosted on a web server using MS Access?? my problem is that
the SQL server isnt on their local network ??
You mean that SQL Server is run by a hosting service? Just because you
run SQL Server on a web server does not preclude anything.
That would depend on the access provided by the hosting company. There
are no problems to access an SQL Server on a remote network, although
you probably have to use SQL authentication. But if the hosting company
does not expose SQL Server to your users, they lose of course.
I think you should discuss with the hosting service what options they
provide.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx