Multi-User Application

[Heather]

I need to set up my application for 15 concurrent users. It will be on a network
and the application will be split into a frontend and backend with the backend
on a server and the frontend on each workstation. I have read in the newsgroups
that a well designed application makes for trouble free and good performance.
What constitutes a "well designed" application.

Thanks!

Heather

[Allen Browne]

There are so many facets to your question, Heather

Tony Toews has a good list of the factors that affect preformance at:
http://www.granite.ab.ca/access/performancefaq.htm

In addition to his suggestions and the basic ideas (such as normalization
and indexing), be frugal about what you load into memory. For example, your
form will be slow to load if it has 12 tabs with a subform into each one and
lots of combos and listboxes that have thousands of records in their
RowSource.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Heather" <ha******@cseducationalsystems.org> wrote in message
news:7q*******************@newsread2.news.atl.eart hlink.net...

I need to set up my application for 15 concurrent users. It will be on a network and the application will be split into a frontend and backend with the backend on a server and the frontend on each workstation. I have read in the newsgroups that a well designed application makes for trouble free and good performance. What constitutes a "well designed" application.