[AccessD] Performance tips anyone?

I agree, John.  Access should handle more than 10-12 users under most 
circumstances, and generally many more than that.  It is very difficult 
to make comparisons in terms of "number of users", as this will vary 
enormously depending on the nature of the application, and the way in 
which the users are hitting the database.

Regards
Steve


jwcolby wrote:
> Anita,
> 
>> I think that 10-12 users is the absolute maximum you will get out of an
> Access database it will continue to get slower over the years as the
> database grows. At some stage you would probably have to upgrade to SQL
> server.
> 
> Errrrr!  Wrong answer.
> 
> I have a database with 25 users in the database every day.  The BE is
> currently about 800 mbytes.  This BE has tables with hundreds of thousands
> of records in some tables, 30K-50K records in the main tables (claimant /
> claim).  I open a VERY complex tabbed form with about 20 tabs on it, with
> subforms on each tab (JIT subforms).
> 
> Users on fast machines open the form in about 1.2 seconds.  Users on very
> old slow machines take about 5 to 6 seconds.
> 
> Speed of the individual workstation is the single largest determinate of
> acceptable speed.  A high speed processor and LOTS of memory (1 gig for
> Windows XP Pro) are essential.  Moving to a 1 gbit lan made a big difference
> as well (which requires a gigabit NIC in the machines as well).
> 
> And of course all of the things you mentioned in terms of FE optimizations.
>