Hello.
I was wondering if anyone had any advice on the following:
I have a database setup on tablet pc's for data collection onsite.
This is then syncronised to extract the data and insert into a holding database where checks are carried out and then imported into a live database sited on a network drive.
However I want multiple users to be able to access this live database from the server and carryout edits etc if required.
I was therefore going to create another database with linked tables to the data in this live database and package it so it can be installed on any machine but will allways link the data to the main so everyone sees the same.
Is this a good idea or is there another way?
Thanks
I was wondering if anyone had any advice on the following:
I have a database setup on tablet pc's for data collection onsite.
This is then syncronised to extract the data and insert into a holding database where checks are carried out and then imported into a live database sited on a network drive.
However I want multiple users to be able to access this live database from the server and carryout edits etc if required.
I was therefore going to create another database with linked tables to the data in this live database and package it so it can be installed on any machine but will allways link the data to the main so everyone sees the same.
Is this a good idea or is there another way?
Thanks
