Access 2003 on Terminal Server 2008

[KPR]

Hi,

I have 15 people Terminal Serving in to our office to enter data into an
Access 2003 database, each with their own TS login account. What database
configuration will give give me the best performance? Should I split the
database? If so should each user have their own front end app?

Thanks,
Ken

 

[Tom van Stiphout]

On Wed, 18 Feb 2009 13:05:03 -0800, KPR

All documentation I have ever seen about this topic SCREAM the same
recommendation: every user must have their own FE.
If you don't like the performance, work at that following the standard
recommendations for split databases, but don't go back to a monolithic
db.

-Tom.
Microsoft Access MVP

 

[KPR]

Thanks Tom, what are the stadard recommendations for split databases?

 

[Tom van Stiphout]

On Thu, 19 Feb 2009 12:04:05 -0800, KPR

I was thinking of this page:
http://www.granite.ab.ca/access/performancefaq.htm

-Tom.
Microsoft Access MVP