A client has asked if it is possible to have his database that is in a main
server connected to a website.
Many of his staff need to access the database from home.
What do you do to achieve this. Can an Access program work through a
webpage.
Yes.
Sharepoint services may be able to achieve what you are looking for.
But there will be a learning curve.
The arguably "right thing" to do is either forget access entirely and
have someone build you a website with an SQL backend.
Alternatively, the easiest thing to do would be to not use a webpage.
Instead use access through VPN/remote desktop. If you choose remote
desktop, your IT folks will have security issues but it's easy if
they'll allow it. If you choose VPN, you will need to make sure your
database is designed to be FAST. The basic gist is you want to make
sure any recordsets (especially those underlying a form) return the
smallest recordset possible: filter FIRST, connect to recordset
SECOND.
Hope that helps, if you let the newsgroup know what kind of scale (#
of users, # of records) you're talking about they can probably suggest
more specific solutions than I can (but they all take a lot of work)
~J
