Two parts to me question...
One
I have a database that will potentially have 50-60 users. It will have a frontend located on each PC. Each user enters data into a form and when they hit enter it adds that data to the backend on the server.
To do this "adding" which is the quickest and safest from a locking perspective...
1. to use a simple "saved" append query to the linked table
2. Open a recordset and add
3. Use an SQL INSERT statement to the linked table
Two
Because users only ever add data to the back end I don't think I'm being too ambitious using access, but am I wrong?
Will 50-60 users possibly appending data at once bring the whole thing down around my head?
Thanks in advance.
One
I have a database that will potentially have 50-60 users. It will have a frontend located on each PC. Each user enters data into a form and when they hit enter it adds that data to the backend on the server.
To do this "adding" which is the quickest and safest from a locking perspective...
1. to use a simple "saved" append query to the linked table
2. Open a recordset and add
3. Use an SQL INSERT statement to the linked table
Two
Because users only ever add data to the back end I don't think I'm being too ambitious using access, but am I wrong?
Will 50-60 users possibly appending data at once bring the whole thing down around my head?
Thanks in advance.