[AccessD] Zip codes within 50 miles

John Skolits askolits at nni.com
Tue Apr 29 09:38:36 CDT 2008


OK then. Thanks.

Note: I also sent you an email offline.

John

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, April 29, 2008 10:26 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Zip codes within 50 miles

John,

This was designed in 2002 most likely, though I always use the old 2000 
file format.

I know absolutely nothing about 2007 so I can't speculate what is going 
on there.

This may in fact be a Windows privilege kind of thing.  I found 
something similar that turned out to be a property of the file itself. 
Apparently at some point Windows started storing what computer the file 
was created on (NTFS property), and then checks if the file was created 
on a local system when it opens.  So it may in fact have nothing to do 
with Access per se.  Once you "converted it down" the converted file WAS 
created on your system so the "problem" went away.

John W. Colby
www.ColbyConsulting.com


John Skolits wrote:
> JC,
> 
> I downloaded, unzipped and I was able to open it in 2007. 
> 
> But when I tried Access 2002 (sp3) I received the error.
> 
> "This file is located outside your intranet or on an untrusted site. ...."
> 
>>From 2007, I converted it down to 2002-2003 and it seemed to work. Does
this
> make sense?
> 
> Thanks,
> 
> John
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, April 29, 2008 8:49 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Zip codes within 50 miles
> 
> see the top entry at this page...
> 
> http://www.databaseadvisors.com/downloads.asp
> 
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> John Skolits wrote:
>> Anyone see any DB or have code for returning a zip code within 50 miles
of
>> another?
>>
>> Thanks,
>>
>> John
>>
>>
>>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list