Multiple Users

permalink · #1 (**permalink**) 28-Jul-2006, 08:30 AM

I currently building a db for a group of 10 users. How would access perform
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12583-multiple-users.html
with 10 users using the db at the same time?

*

permalink · #2 (**permalink**) 28-Jul-2006, 08:30 AM

I have created a database which is currently used by 10 -15 people at
the same time on the server in my office. I have had very little
trouble. Problems will likely surface though if multiple people try to
update the same record at the exact same time so you have to be careful
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12583
for that.

permalink · #3 (**permalink**) 28-Jul-2006, 08:30 AM

What changes did you make to prevent that?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12583

"Glen T" wrote:

> I have created a database which is currently used by 10 -15 people at
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12583
> the same time on the server in my office. I have had very little
> trouble. Problems will likely surface though if multiple people try to
> update the same record at the exact same time so you have to be careful
> for that.
>
>

permalink · #4 (**permalink**) 28-Jul-2006, 08:30 AM

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). Only the back-end should be on the server: each
user should have his/her own copy of the front-end, preferably on his/her
hard drive.

Read what Tony Toews has to say about this subject at
http://www.granite.ab.ca/access/splitapp/index.htm
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12583

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Pizza" wrote in message
news:A8307EF6-5555-4E8D-848A-7D41FCD466BA@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12583
> I currently building a db for a group of 10 users. How would access
perform
> with 10 users using the db at the same time?

permalink · #5 (**permalink**) 28-Jul-2006, 08:30 AM

Sorry for the late reply Pizza. I have been in meetings most of the
day. I had the DB set up just as Douglas has specified. I didn;t want
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12583
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12583
to have users working directly in the tables so I created a front end
and a back end. Obviously, the front end used a bunch of queries and
forms to update the records and create reports.