I'd like to do this:
Have a SQL Server database hosted on a public facing web server.
I want it to be held at an ISP/Web hosting company. Though I have ADSL here
I don't want to manage a server.
I want some ASP pages accessing the database.
I would also like for a very small number (probably 2) of users to access
the database from a richer client. Perhaps Access/VB.
I've tried using www.shanje.com, as a test. It seems to work, though there
are worries about security.
I want to keep cost down!
On 'normal' shared MS hosting, would it be possible to connect to the db
from a client like Access. The way most web hosts talk it doesn't look like
it.
Is there any way of providing a richer client interface than plain web
pages? I want things like autocomplete (beyond the first character) for drop
downs, keyboard shortcuts etc.
This would be low volume. Essentially a private database held on the
internet.
Yours, Jo