Greg S
weeden1949 at hotmail.com
Mon Apr 14 10:11:36 CDT 2003
Bill: I have a client that is setup with the FE on each workstation (approximately 20) and the BE resides on their RAID server. The main copy of the FE resides on the server as well. When they startup each workstation for the day, their SA wrote a script/batch file that runs and places a fresh copy of the FE from the server onto the corresponding local machine. It works really well. The users don't even notice the slight delay (probably out getting coffee anyway...) and they start with a new FE every morning. The added benefit for me is that all I have to do to make changes is login to their network from work or wherever I am at the time, copy down the latest version, make sure the links are ok, and I'm done. The next time they startup, they all have the latest version that next day. Greg Smith ----- Original Message ----- From: "Bill Morrill" <bmorrill at attbi.com> To: <AccessD at databaseadvisors.com> Sent: Monday, April 14, 2003 8:14 AM Subject: [Accessd] FE/BE on server vs FE on workstation/BE on server? 4-14-03 For sometime I have been putting frontends(forms, queries, reports etc) on workstation machines and backends(tables) on server. Links would then be made from each workstation to the server. Recently, a user mentioned that they were using the same database frontend/backend on the server. Each user would activate the frontend on the server and then the backend on the server would of course be linked to the frontend. They said this shared backend/frontend situation worked fine and that there was no need to put the frontend on each workstation. Anyone know the ramifications for this frontend/backend on server idea? Does this impact the network performance? Does this reduce the maximum number of concurrent users? Would Access have to be installed on the server to make this viable? Thanks in advance, Bill _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com