Using Access with concurrent users

From: Jeff C (JeffC_at_discussions.microsoft.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 06:49:03 -0800

Hi,

I know this is a common topic, but I have some questions relating to Access
in a concurrent user environment that I haven't seen before. As mentioned
many times, Access doesn't exactly have the best performance when multiple
users are accessing the database at the same time. Can someone send a good
link of a webset that recommends how to set the database up for optimal
(relatively) performance? I'm aware of splitting the db up into front end
and back end, etc.

Two other questions I had were relating to user management. Can I track
which users are accessing the database at any given point in time? Even if I
tracked which users were accessing the network share in which the db resides.
 Also, I heard of opening the database exclusively, which I think means I
have exclusive access to the database at that time. This is what I want. I
want to be able to boot other users off and have complete access to the
database to back it up.

If anyone has any other tips on doing this, they would be appreciated.

Thanks,

Jeff

Relevant Pages

  • Re: Search efficiency - RDMS search versus free text search
    ... so for example a list of all resources relating to ... One way of doing this is with a SQL query against the database ... the engine itself will do full text indexing for ...
    (comp.databases.theory)
  • Re: OT: SQL & Dave
    ... thing your woman would complain about would be your database of the ... when where why and how relating to your sex life together. ...
    (alt.fan.letterman)
  • Re: OT: SQL & Dave
    ... thing your woman would complain about would be your database of the ... when where why and how relating to your sex life together. ...
    (alt.fan.letterman)
  • Re: I need help creating a new database
    ... track, and defining those entities, then relating them to each other; ... > I have worked on this database for days and it still doesnt seem to make ... > need to create this database for the purpose of Loans showing these tables ... > I need to be able to print a report that gathers all the customers who ...
    (microsoft.public.access.gettingstarted)
Loading