multiple user using single form

[mghdb]

I have a database that holds work assignments for employees. I have an text box labeled txtEmpID, which the employees would enter their ID and hits a command button labeled cmdAccept. The command button is referencing a query which uses the text box as a criteria to requery. This all works but for a single user. I'm afraid that there might be problems if multiple user use this method. Is there a better way to accomplish this? Thanks in advance for any help.

 

[Rich@ITTC]

I do not think there would be a problem with what you want to achieve if the users each have a front-end database on their workstation and a back-end database on the server (with only the tables stored here). Each user would then be running their own version of the form (and underlying query) on their workstation. You might have to make adjustments to record locking (optimistic/pessimistic) if there were occasions when the users edited the same record at the same time, but otherwise this should work perfectly well with no problems.

HTH

Rich