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