Hi everyone,
I'd really like some advice on this. I have just finished a database I've been working on (thanks to everyone who helped me) and I just split it so that the tables are on the server and the front end will be on the users machines.
Its a drawings register and many of the users will just need to browse the drawings to see the drawings and revisions that are there. These users will not be able to add or delete records (I presume I do this by setting up a usergroup and permissions?)
They can sort and filter the records in different ways on a datasheet form. They can update only one field in the table and that is the 'selected' field (checkbox on the form). If several users are using it concurrently it will interfere with the drawings that others have selected. From what I understand, I could replicate the tables they would use? Is this the correct way to do this even though the database is split? I'd really appreciate any tips as I've been reading alot on this but am still v unsure..
I'd really like some advice on this. I have just finished a database I've been working on (thanks to everyone who helped me) and I just split it so that the tables are on the server and the front end will be on the users machines.
Its a drawings register and many of the users will just need to browse the drawings to see the drawings and revisions that are there. These users will not be able to add or delete records (I presume I do this by setting up a usergroup and permissions?)
They can sort and filter the records in different ways on a datasheet form. They can update only one field in the table and that is the 'selected' field (checkbox on the form). If several users are using it concurrently it will interfere with the drawings that others have selected. From what I understand, I could replicate the tables they would use? Is this the correct way to do this even though the database is split? I'd really appreciate any tips as I've been reading alot on this but am still v unsure..
