<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#3366ff">
Andrew Hammond wrote:
<blockquote
cite="mid5a0a9d6f0607231403i3d4dbb2er38937e687cfa7805(at)mail(dot)gmail(dot)com"
type="cite">Have you considered using the ODBC driver to plug your
access front-end into a postgres database?<br>
<br>
<div><span class="gmail_quote">On 7/23/06, <b
class="gmail_sendername">Fred Frazelle</b> <<a
href="mailto:frazelle09(at)yahoo(dot)com">
frazelle09(at)yahoo(dot)com</a>> wrote:</span>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div bgcolor="#ffffff" text="#3366ff"><tt>Have looked far and wide
and haven't found one yet. Have tried<br>
Navicat, DbWrench, EDb-win32, PGAdmin III, and several others. All<br>
pretty much allow table creation and i can link my two tables and some<br>
even allow queries but when i run the query, all i get is the first<br>
row. But the supposedly the automatic ID is not inserted and even<br>
though i can insert data into the first row, the ID must be inserted by<br>
hand. Don't know what to do. Am waiting on OpenOffice to upgrade<br>
their driver or whatever it is they need to upgrade in order to create<br>
linked queries which are able to not only select but update the db as
well.<br>
Any ideas?<br>
<br>
A little background... i've been looking for more than a year now and
want<br>
something which is multiuser bec. there are about 15 of us in our<br>
child development department office. We put an Access db together<br>
ourselves which serves our needs pretty nicely but our IT Dept. wants us<br>
go out and buy another program bec. Access chokes or coughs at least a
couple of times a week and they say it's bec. we have too many users
trying to<br>
access it at once (15 is too many?). Our db only holds about 1500<br>
records and we've maybe got 3 linked tables. It's pretty simple but we<br>
were able to put it together ourselves and have been able to convert<br>
all our old paper forms to Access and make up all of the reports the<br>
state and county need. We figure if we can find a way to use<br>
PostgreSQL by ourselves and port? over most of the tables and at least<br>
some of the forms and reports to begin with, we could convince our IT
dept. and our<br>
boss not to spend the taxpayers money on another propietary db. Besides
the new one they are thinking about buying cannot be modified by us. <br>
<br>
None of us are programmers. We work with the public. We've gotten as
far as being able to download and install PostgreSQL and have been able
to set up the server? and have created a couple of tables and linked
them. That's it. Who<br>
knows, maybe one of these days we can even convince them to use a real<br>
OS like Linux which would save even more. Well, here goes. Have a<br>
great day! :)</tt>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
<font face="Palatino Linotype">Thanks Andrew!<br>
<br>
Yes, we have considered this approach, but we are trying to develop
an alternative to MS now so that when the IT dept. comes around the
next time and offers us an upgrade to the MS Office suite, we can have <br>
our alternative working and be able to suggest to them that they
investigate some other Office suite, for example Open Office, and that
we also have a db solution to Access.<br>
Have a great afternoon and thanks again! <span
class="moz-smiley-s1"><span> :-) </span></span><br>
</font>
</body>
</html>