C
C.Voce
I am considering starting a business offering a cataloguing and library
management system to potentially hundreds of clients. Individual clients will
ideally have their own custom-made databases, although all of them will have
essentially the same features, altered slightly from case to case.
I would like to have a main table of data (common to all clients) which only
I can add to and edit, and then give clients the ability to copy any number
of records from this table into their database, also adding in other
information to related tables (which will differ from client to client). I
will need to give clients access to forms and reports, but also ideally have
the ability to monitor all of their data input remotely for the purcposes of
checking and consistency.
Would this be possible using SQL Server - having my main table on SQL
server, and then giving an .accdb file to my clients, linked to my main
table? Or will all the information need to be stored on my server in order
for me to be able to edit it? Alternatively, would Sharepoint better suit my
needs.
Any guidance greatly appreciated.
management system to potentially hundreds of clients. Individual clients will
ideally have their own custom-made databases, although all of them will have
essentially the same features, altered slightly from case to case.
I would like to have a main table of data (common to all clients) which only
I can add to and edit, and then give clients the ability to copy any number
of records from this table into their database, also adding in other
information to related tables (which will differ from client to client). I
will need to give clients access to forms and reports, but also ideally have
the ability to monitor all of their data input remotely for the purcposes of
checking and consistency.
Would this be possible using SQL Server - having my main table on SQL
server, and then giving an .accdb file to my clients, linked to my main
table? Or will all the information need to be stored on my server in order
for me to be able to edit it? Alternatively, would Sharepoint better suit my
needs.
Any guidance greatly appreciated.