database traffic

[campbellbrian2001]

I have a conceptual question. I'm in the preliminary stage of writing
an Access2000 application which is going to have about 3 users at a
time producing retail costing of a product. The ecompany has about 50
different pieces of equipment each having about 20 fields of physical
properties (i.e. speed, hourly rate, etc.). My concern is if I set up a
table for each piece of equipment that will have to be opened to
"build" the final costing, there will be conflicts with the traffic in
and out of these tables if there are 3 users working at a fast pace.
Any advice?
Thanks all in advance!
Brian

[Keith]

ca***************@yahoo.com wrote:

I'm in the preliminary stage of writing
an Access2000 application which is going to have about 3 users at a
time producing retail costing of a product. The ecompany has about 50
different pieces of equipment each having about 20 fields of physical
properties (i.e. speed, hourly rate, etc.). My concern is if I set up a
table for each piece of equipment that will have to be opened to
"build" the final costing, there will be conflicts with the traffic in
and out of these tables if there are 3 users working at a fast pace.
Any advice?

So long as you give each user their own FE I can't see 3 concurrent users
being a problem no matter how fast they work. There could be a situation
where a user starts writing to a record and leaves it dirty but you could
write code to overcome that.

Regards,
Keith.
www.keithwilby.com