PDA

View Full Version : [SOLVED] Multiple users



paulked
10-13-2017, 06:46 AM
Hi all.

I'm about to start a project for an EPOS system where there are numerous users with common (shared) data.

I'm thinking of a master shared workbook, on a network drive, with each of the users having a tablet with a slave workbook with a 'dashboard' to take orders and payments. These slaves will update the shared master workbook.

Anyone think this is the wrong way to go about it or, indeed, is there a more efficient way?

Many thanks

Paul Ked

SamT
10-13-2017, 07:07 AM
AFAIK you can't share Excel for Writing. Only one instance can Write, the rest can only Read.

But a small Access DB, (or any DB,) between the Master and the Tablets should work out.

You can also put a WAMP on the server and use the Master Workbook to serve html Forms that the Tablets can use.

If you do use Excel exclusively, add an intermediary flat file, (*.csv, *.txt, etc,) to the Server, which the Tablets only open very briefly to set Orders and the Master only opens briefly in Read Only.

paulked
10-13-2017, 07:14 AM
Many thanks for prompt reply, food for thought...