Error message appears when multiple people Access Database

[NewBridge]

Hi,
When multiple people doing data entry within and access database at the same time by entering unique records, an error message appears saying that there is someone else in the file and it cannot save any changes. I am using access 2003. Is it not possible for multiple people to access the database at the same time. Any suggestions.
Thanks in advance.

[TonyES]

Hi,
As per my experience and knowledge there should not be a problem with that, where as you can't have multiple people making design changes etc but just entering data should be fine. The obvious solution would be to split the database assuming you haven't done so already, give each user their own copy of the front end with all linking to the same back end. Or just install the runtime client (not the full access) and then it is never asks. Plus if you get the office developer package, you can install it on any machine that you have created a database for.
Cheers!

[NewBridge]

Thank you!

[Agostino]

Hi,
I wood like to run my database without the main window to discourage people from "playing". Even when the main main is disabled, it still doesn't look "pro". I'd like to start my switch board against a solid color background, like a blank desktop. Any suggestions would be appreciated.
Thanks.

[Hippo86]

Hi,
I'm working on a report that lists locations that are in exception. these locations have ratings such as A,B or C. Using Count([location]) on the report I was able to obtain the total number of records appearing on the report, but I can't figure out if theres an easy way of using the count method to determine the total number of records for each rating. for example, if theres a total of 12 locations, 4 that are A, 2 that are B and 6 that are C.
Any suggestions would appreciated.

[TonyES]

Hi,
I found an useful link posted in Eng-Tips related to your query please click on the below link for more:

Hide The Access Window

Cheers!

[TonyES]

Hi,
A starting point:
Sum(IIf([rating]='L'),1,0)

Hope This Helps.

[Agostino]

Thank you TonyES, I saw the link and it was very useful.

[Hippo86]

Appreciate for the quick response. It was really helpful.

[TonyES]

Thanks, great to hear that it was helpful to you.
Cheers!