Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Mon Oct 22 12:56:46 CDT 2012
I *never* use anything *but* UNC paths for linking table - admittedly these are direct links via the Access UI, not ODBC links. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, October 22, 2012 1:17 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Changing the ODBC Connection String to use UNC - Strange Results IIRC (from the distant past) UNC connections have never been reliable with linked tables. I don't recall much more, it seems to be a long standing bug, never fixed? If you think about it, this is not a "power user" requirement and we all know who the target audience is (hint - not the developer). John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 10/22/2012 10:36 AM, Brad Marks wrote: > All, > > We have an Access 2007 application that connects to a FireBird > Database via ODBC. > This application has worked nicely for several months. > > There is both a Test and a Production copy of the Firebird Database on > a server. > > I have mapped one drive to point at the Production database and mapped > a second drive to point at the Test database. > > There is VBA code that switches between Test and Production by > changing the DbName in Tabledef.Connect. > > This works nicely with the mapped drives. > > Recently, I had the idea of using a UNC instead of the mapped drives. > I wanted to do this because more users need to access the Test > database and I wanted to avoid the need to set up mapped drives on > additional PCs. > > I changed the VBA code to use the UNCs and I am now seeing > inconsistent results. > > Sometimes the switch between Test and Production works, sometimes it > does not. (Error 3151 - ODBC Connection Failed). > > Has anyone else ever run into this issue? I have tried many tests and > I cannot understand why this is happening. > > Thanks, > Brad > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com