Guest rick Posted November 27, 2007 Posted November 27, 2007 (I cross-posted this to the Access General forum but it is more a question for those who understand the fundamentals of server technology.) I am unclear on the concept (maybe) ...? I have a Windows2003 SBS and have connected a full Win2003 server to the SBS domain to function as an app server. We maintain all our company data (User Data Files and databases) on the SBS. Users connect to the App Server to run programs against the databases (Crystal Reports, Web Time Off, etc.). I developed an Access database some years ago (Access2003) and it is still running at a dozen or so sites in town. The database has been split into an FE and a BE. I would like to repatriate all these databases from the various sites and place the FE and multiple BE's on the SBS then have the Users RWW into the SBS and then connect to the Application Server. I could make some code changes to the startup routines of the FE to ask the User what site they wish to use, get a password and then link them to the correct BE. Where I am not clear is - when the User logs on to the App Server do they get a 'private workspace'? If so, then the FE is loaded into their w/s and would be completely independant from other FE's in the same server? The SBS does not have Access loaded and I would propose to load the Access Runtime environment (or full Access if need be) on the App Server. Am I correct in assuming that I can run multiple copies of the same FE on the App Server yet have each linked to different BE's on the SBS? Thanks for your insight. Rick
Recommended Posts