End-User Specific Query

[aroth]

I'm in a bit of a bind here. We are rolling out a database that will have the potential of 200+ employees accessing it simultaneously. It's basically a form frontend with a basic data table backend. The set up is simple, but now when multiple submit, there is the possiblity of overlapping requests.

For example, say John Doe accesses the form and starts to fill it out, a minute later Jane Doe access the form and fills it out and submits it before John. Jane's report comes through clearly, and John's looks exactly like Jane's report.

Right now I have a SendObjects macro that emails a report based on a select query that results in the most recent record created. (Top Value 1 with Request ID sorted in Descending order). I am looking for a way to query the most recent record created by the user. For example, when John Doe submits his report, the query will pull his submissions and not Jane's.Is this possible?

Any help would be greatly appreciated.

Thanks.

 

[boblarson]

The frontend needs to be a separate copy on EACH users machine. If you put it on a file server and everyone accesses it through that I can guarantee you will suffer continued corruption.

Read this: http://www.members.shaw.ca/AlbertKallal/Articles/split/

And if you use my Frontend Auto Update Enabling tool, it will enable you to do auto updates of your frontends. Yes, the first distribution you will need to get it to people somehow and that is in your court. But, if you have enabled auto updating, then you can just go into your master file on the network, make your changes, change the version number in two tables (one in the frontend and one in the frontend that is linked to the backend), then when your users open their frontend and the version numbers don't match it will tell them that their frontend is out-of-date and it will close, delete the old file, copy the new file, and then reopen for them automatically.

I had to create this for a big healthcare provider I worked for which originally had over 100 users using a single mdb frontend on the server and they wondered why it crashed each week, or several times each week. So, once we implemented this and moved to frontends on each user's machine, they never had a corruption issue again as long as I was there.

You can download it here:
http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx