Brad Marks
BradM at blackforestltd.com
Tue Oct 22 15:07:51 CDT 2013
All, I believe that I have found a solution. I wrote a small script that uses "Net Use" to establish a mapped drive when the Report Job is being run in "logged off" mode. This script is automatically run before the generation of the Access reports. This approach seems to work in my initial testing. I have never used the "Net Use" command before and I have a little concern that this might not be the best approach, but it seems to work so far. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Tuesday, October 22, 2013 10:01 AM To: Access Developers discussion and problem solving Subject: [AccessD] Running Access Reports While Logged Off - Mapping Problems All, I have a number of Access reports that pull data from a purchased product Firebird Database via ODBC. These reports have worked nicely for several months running on a local PC. I would now like to move the execution of these report jobs to an application server. Currently when these reports are run on the local PC (always logged on) I employ a drive mapping to map the "Y" Drive to a server as shown here - Manufacturing on 'BLKFST10' (Y) This works nicely, when the reports are run on the local PC because I am always logged on to this PC. When I started to move these report jobs to an application server, I thought that I could simply use "UNCs" and change all references to the "Y" drive to \\BLKFST10\Manufacturing I believe that this is needed, because the report jobs will be run in a "logged off" mode and therefore drive mappings will not be available. The catch is that when I try to change the Firebird ODBC Database Path to use a UNC, it can no longer successfully connect to the database. It appears that this ODBC connection will not support UNCs. Any ideas/insights would be most appreciated. Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=1ECB928D07.80A42