advice on access

C

Chris

I currently use a excel spreadsheet to store data and have set it up on a
web folder to allow access to other users to view and change data. This
method is not the best way since only one user can change the data at a
time. What are the alternatives where users can access the data and change
it whether someone else is using the file or not? Would access be the best
way forward?
 
A

Arvin Meyer [MVP]

Access allows multiple users to change records (not the same record, nor the
same page of records) at the same time. The chances are that users will not
be changing the same record(s) anyway.

You can use a web front-end to an Access data back-end, or use a Terminal
Server connection to the back-end, and avoid the web server altogether.

It is always wise to use a separate forms, front-end to the data tables on
the back-end so maintain control of the data. Otherwise a user could
accidentally delete all the records, as they can now in Excel.

In any case, Access is superior to Excel for storage and retrieval of data,
and Excel is the better analysis tool.
 
C

Chris

Arvin Meyer said:
Access allows multiple users to change records (not the same record, nor
the same page of records) at the same time. The chances are that users
will not be changing the same record(s) anyway.

You can use a web front-end to an Access data back-end, or use a Terminal
Server connection to the back-end, and avoid the web server altogether.

It is always wise to use a separate forms, front-end to the data tables on
the back-end so maintain control of the data. Otherwise a user could
accidentally delete all the records, as they can now in Excel.

In any case, Access is superior to Excel for storage and retrieval of
data, and Excel is the better analysis tool.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Click to expand...
Many thanks for that info. Are there templates available which I can
download and assess against my requirements based a web front end?
 
Top