var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Large distribution of A2K mde file
We have developed an Access 2000 front end with several linked tables connected to a SQL Server 2000 database.
The front-end is to go on a network and will be accessed by up to 100 users.
The front end will be used for data entry and reporting. The PC's will be running XP.
Should the front-end be on the network or would it be better to have a copy local to each PC ?
If the mde front-end was on the network what performance issues are there with having multiple users ?
why would you want static stuff like forms, code, etc. crawling down your network instead of sitting on the client where they belong?
you've solved the 100 users problem for the data by moving it to sql serving ...wouldn't it be a tragedy to recreate a new problem with the front-end?
Putting the front-end on the client was always the most intellectually satisfying.
I was thinking about the maintenance - updating the front-end when things change - but I guess the network should be able to handle distributing updates.