Inquiry

[Guest]

I have a database on a shared folder that will be used by 7 agents on the
same time,they will add records to it , I'd like to know whether there will
be any problem if all the 7 guys uses it on the same time ???

 

[Guest]

Generally you should split the Access DB between Front End & Back End . Put
the FE on each agent's PC and the BE in the common folder.

With standard record locking embedded inside Access you won't have any
conflict (unless 2 want the exact same record at the exact same time - in
which case it is first come first served....and the 2nd agent will be told he
can't)

If you just use a shared Folder for the whole DB - then am not sure whether
Microsoft will allow the same db to be opened by different people at the same
time...

 

[Albert D. Kallal]

you should not have much of a problem, but you do need to split your
database for reliable operation.

I explain how/why here:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Guest]

Thank you very much for your prompt reply
Please note that I'm a new to use Access so i know nothing about Front End &
Back End ,FE ,could you tell me how??