I need to coordinate file management between three computers.
Users need to enter all file names and would like to store file
names,date changed,person
changed etc. into a database. User Friendliness is main priority.
I would like one machine acting as database server on which data
entries will be stored.
The entries can be made by any of the three machines using a front end
interface.
Also using the front end the user should be able to query the database
to get results based
on certain keywords(like part of paper name) in addition to search
based on paper
name,date changed. The database has to be backed up
periodically(preferably automatically).
I am thinking of using Visual Basic as front end. For back end is
Access possible to use(can
it be set up to act as server on one machine which can service queries
from other machines
as well as its front end client) or other databases(SQL,MySQL,Oracle)
which support such
functionality need to be used.
I would appreciate any feedback for the front end,back end and design
considerations.
P.S. I am quite new to this so please excuse my faults. Please excuse
me for reposting but I did not get any feedback from previous post.