<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16735" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2>Anything you can do in PgAdmin you can do with a pass-thru
query in MS Access.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2>Take a look at this article which demonstrates making a
TSearch query with a pass-thru MS Access query.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2><A
href="http://www.postgresonline.com/journal/index.php?/archives/24-Using-MS-Access-with-PostgreSQL.html">http://www.postgresonline.com/journal/index.php?/archives/24-Using-MS-Access-with-PostgreSQL.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2>You would do the same thing with PostGIS spatial queries,
though won't display spatial data, but I use they same technique to call my
geocoding/proximity Postgis functions/views/ahoc spatial attribute
queries from MS Access.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407053212-24122008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Pablo<BR><B>Sent:</B> Wednesday, December 24, 2008 6:05 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] spatial
queries in an ODBC connection<BR></FONT><BR></DIV>
<DIV></DIV>Hi!<BR>First of all, sorry about my english, is not very
welll...<BR><BR>Well... someone can tell me if I can use the postgis functions
(buffer, crosses, etc etc...) from a form in access or open office database via
ODBC?<BR><BR>The question is that Ihave an spatial database created with lines,
polygons, etc. And I have a lot of spatial queries. There is no problem when I
run them in pgadmin. But what I want is make an easy form in order that other
people can connect with the server via ODB, and run the spatial queries.<BR>When
I try to make simple queries (select from tables, etc) its all OK, but when I
type compley queries in access, it tells me that the functions are not
available.<BR><BR>Some body knows if can I make spatial queries in a form?<BR>I
don't mind if is in access, open office, or other. I accept
suggestions.<BR><BR>Thanks a lot!<BR><BR>Pablo<BR></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>