Data on internet

C

Colin Hammond

Is it possible and practical to store all the data for a project on the
internet so that a select group of people could access and update the data?
Would I need extra software to achieve this aim?
Where should I start reading?

We use Access 2000

Colin
 
A

Anthos

Is it possible and practical to store all the data for a project on the
internet so that a select group of people could access and update the data?
Would I need extra software to achieve this aim?
Where should I start reading?

We use Access 2000

Colin
Click to expand...

Colin,

With Access 2000, you could potentially have a SQL Database on the
internet, but that would be rather poor security practice (having it
open to the internet)

I would suggest something like Sharepoint 2007 and MS Access 2007,
This allows you to store the data in a webpage type application, as
well as take the database offline.

(I know it doesn't fall into your requirements of Access 2000, but for
the effort in upgrading, it certainly wouldn't hurt)
 
S

Steve Schapel

Colin,

As long as the volume of data is not huge, Anthos's idea of using Access
2007 with SharePoint may well be a good solution. You probably wouldn't
need "SharePoint 2007" - the free Windows SharePoint Services 3.0 should
do the trick.

Another approach would be to use Terminal Services, so the users access
and run the database remotely. Albert Kallal has some information at
http://www.members.shaw.ca/AlbertKallal/Articles/ThinClientsand.net.html.

If the "select group" numbers less than 21 concurrently, you might also
look at this remote access solution, which I am using with good success:
http://www.thinsoftinc.com/product_thin_client_winconnect_server_xp.aspx
 
A

Anthos

Steve,
You are right, WSS 3.0 would be fine,
I have a bad habit of using Sharepoint 2007 and WSS interchangibly....

Colin,
Sharepoint 2007 requires CALS per user, where as WSS is a free
download from Microsoft, and I believe doesn't require CALS.
 
Top