Jim Dettman
jimdettman at verizon.net
Sun Oct 8 06:38:41 CDT 2006
Jennifer, << We are having data corruption and the new guy says it is because of Terminal Server - too many connections to the back end from the same box. I know very little about the network/hardware/software aspects and am at a loss. >> The TS connection settings should be checked. When a connection is dropped, there are various things TS can do; retain the session so you can reconnect, log it out, etc. What you don't want is for it to be logged out. That means Access (and any other running apps) will get terminated whether they want to or not. The other place where TS bites you is references. Unless you change references on the fly or distribute a special TS version of your FE, all users will have references (usually to the local C drive in most cases). This means they are all sharing those references even if you've given them all a separate copy of the FE. With Dll's and type libs, that's not a problem, but if it's a .MDA add-in, you might have some issues with that. Using some of the Access Wizards under TS requires workarounds because of this. Beyond that, running TS is no different then a bunch of client PCs all connecting to the BE in terms of connections. In fact, it's a lot more stable. If I could run Access under TS vs the "normal" way, I'd choose TS hands down every time. Jim. BTW, how many users are we talking about? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer Gross Sent: Friday, October 06, 2006 11:16 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] ODBC Hi Stuart, Do you have experience with Terminal Server with multiple users running separate front ends to a common Access data file? I would love to pick your brain if you do - or anyone else for that matter. I currently have a new IT guy who is in conflict with the old IT guy about our use of Terminal Server. We are having data corruption and the new guy says it is because of Terminal Server - too many connections to the back end from the same box. I know very little about the network/hardware/software aspects and am at a loss. I have made no changes to the database, yet in the past two weeks we have experienced several "corruptions", when the database had been stable for nearly a year without a corruption. Any help would be appreciated. Jennifer -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Friday, October 06, 2006 8:05 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] ODBC On 6 Oct 2006 at 19:09, Jennifer Gross wrote: > Question 1: When an Access front end connects to an Access backend is > it an ODBC connection? No, it's a JET connection, which is more efficient than ODBC > Question 2: If multiple users have separate front ends on the same > Terminal Server box linking to a back end on a different box, are they > opening separate connections to the back end (ODBC or otherwise), or > are they sharing the same connection? They are separate connections. -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com