[AccessD] When it rains it pours!

John,

Your mention of a UNC reminded me of a funny incident a couple years ago that cost me $100.

I was working on an Access 2007 reporting application that was set up to run after hours in a "Terminal Services" environment.  In the past, this application was simply pulling data from SQL Server, generating reports, and e-mailing these reports to select employees.  This was all working fine until one day when it became necessary to obtain a small amount of data from an Excel file.

When I set things up to obtain the data from the Excel file, Access automatically inserted the path of the Excel file with the "Mapped Drive".  All of my tests worked fine, but when the application ran at night, it would hang up.  I spent several hours working on this.  The application would always run nicely when I was logged on, but would never run successfully when I was logged off.

In frustration, I said "I will give $100 to anyone who could explain why this is happening".  My oldest son heard me say this and said, "You better use a UNC as the drive mappings are not in affect when you are logged off".

Boy did I ever feel stupid.  I added the UNC, conducted a successful test while logged off, and handed my son five 20-dollar bills!

I have never made this mistake again.

Brad      
    


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Darren
Sent: Mon 7/15/2013 9:08 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] When it rains it pours!
 
Hi john
Broadly speaking using the double backslash then share/ip address should
work fine in your linking/re-linking
E.g.    \\SomeShare\SomeFolder\SomeMDBFile.mdb - should work fine.
I would like to say "regardless of the network type" but I'm not a network
nerd and know little of such things
D

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Tuesday, 16 July 2013 5:11 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] When it rains it pours!

OK...I've figured it out...by accident really. 
 
I had to type the UNC path into the "File Name" box, and it appears to let
me enter it. It seems to have worked for the program I inherited today...our
Pistol Permit office. However, I'm having some issues w/the one I've spent 3
days on...our Risk Management dept...of course I'd get a problem there; the
whole things has been problem after problem. But, this is rights I
think...nothing y'all can help with there. 

Notice: This electronic transmission is intended for the sole use of the
individual or entity to which it is addressed and may contain confidential,
privileged or otherwise legally protected information. If you are not the
intended recipient, or if you believe you are not the intended recipient,
you are hereby notified that any use, disclosure, copying, distribution, or
the taking of any action in reliance on the contents of this information, is
strictly prohibited. Niagara County is not responsible for the content of
any external hyperlink referenced in this email or any email. 
IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER
IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR
ELECTRONIC COPIES. 
Thank you for your cooperation.

-- 
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=935E328960.6B0C4