Limit to number of inquiries?

[Moxioron]

Hello.

I have a form that retrieves information from a query (which of course uses data from a table).

Everything is working great and I want to roll it out. However, will multiple users accessing the form/query/table at the same time corrupt the database or not return a result?

Thanks.

 

[boblarson]

The answer is no with a caveat. The database should be split and EACH USER needs to have their OWN COPY of the frontend or else you can be at high risk for corruption.

 

[Moxioron]

Ouch. That seems messy and confusing.

We are talking about 50 users. Any other suggestions?

 

[boblarson]

Ouch. That seems messy and confusing.

We are talking about 50 users. Any other suggestions?

Only messy if you choose it to be messy. What I did when I worked for a healthcare company is came in and found they had issues constantly with corruption. I figured out they had been opening up the same database frontend with all 100 different users (not all simultaneously). I told them the same thing I told you and my co-worker was aghast and said, "No, No, No, we don't want to have to try to install on each desktop when the frontend changes." I told her she didn't have to and I would deal with it.

So what I did is create my Frontend Auto Update Enabling Tool which is located here:
http://www.btabdevelopment.com/ts/freetools
I give it away for free. So you just need to get the initial distribution done and after that it is all done automatically when you change the version number in two tables.

 

[Moxioron]

Thanks for your response and the tool. I will give it a try.