Database multi sharing error.

[away2play]

I have just finished making a database which have about 10 tables, 80+ queries/forms/reports and have placed it on a local network with multiusers accessing it at the same time (bout 10 users on at a time).

The problem I'm getting is that i think someone is lagging on the network and causing the database to say that it was not closed properly when another person wants to access this . . easy fix atm is to tell everyone to hop off and repair it . . but what i really need to know is how to fix it so it doesnt happen.

I've been looking at the options advance tab and was wondering if changing any of the refresh/timeout rates might fix the problem.

What settings should they be at as any bit of text i can find doesnt seem to help.

Would I be better off splitting the database data and interface and runnin it that way (dont really want to do this as its still being updated and dont want to install it on the 20pc each time i do an amendment)

Sorry bout being so long winded.

Thanx in advance

Garry

 

[ElsVanMiert]

This problem is very complex so I just can ask some complementary questions that might point you into the right direction:

Do all users have DELETE rights for the backend directory?
Are all VBA objects properly destroyed?
Do all users leave your application correctly (and not using the power switch or CTRL-ALT-DEL). This leads to the question: is your application stable and fully error-trapped and (!) are lock errors completely solved (randomized intervals +)?

BTW: The number of tables and other database objects is irrelevant.
If you pass to more users the problem will probably aggravate and you will need a very good lawyer.