I have built a multi-user Access 2002 database over the last 10 years for a
client. There are roughly 20 users on individual workstations and 6 on a
Terminal Server. The application is split into 1 frontend and 5 backends:
3
of the 4 backends are on 1 server, 1 is on each client (lookups and work
tables), 1 is on a second server. The front end is on each client. Current
response times are satisfactory.
I plan to convert 3 of the backends to SQLServer in a few months but may
need to buy some time.
This is my question: is there a performance penalty from having multiple
backends? One of the backends is approaching the 2 GB limit. What effect
would there be from splitting some of the tables out of this backend and
having 6 backends instead of 5?
Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Patrick Jackman
Vancouver, BC
604-874-5774
