Re: Is there a gui front end for this wonderful db program which works like MSAccess?

Have you considered using the ODBC driver to plug your access front-end into
a postgres database?

On 7/23/06, Fred Frazelle <frazelle09(at)yahoo(dot)com> wrote:
>
> Have looked far and wide and haven't found one yet. Have tried
> Navicat, DbWrench, EDb-win32, PGAdmin III, and several others. All
> pretty much allow table creation and i can link my two tables and some
> even allow queries but when i run the query, all i get is the first
> row. But the supposedly the automatic ID is not inserted and even
> though i can insert data into the first row, the ID must be inserted by
> hand. Don't know what to do. Am waiting on OpenOffice to upgrade
> their driver or whatever it is they need to upgrade in order to create
> linked queries which are able to not only select but update the db as
> well.
> Any ideas?
>
> A little background... i've been looking for more than a year now and want
> something which is multiuser bec. there are about 15 of us in our
> child development department office. We put an Access db together
> ourselves which serves our needs pretty nicely but our IT Dept. wants us
> 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
> access it at once (15 is too many?). Our db only holds about 1500
> records and we've maybe got 3 linked tables. It's pretty simple but we
> were able to put it together ourselves and have been able to convert
> all our old paper forms to Access and make up all of the reports the
> state and county need. We figure if we can find a way to use
> PostgreSQL by ourselves and port? over most of the tables and at least
> some of the forms and reports to begin with, we could convince our IT
> dept. and our
> 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.
>
> 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
> knows, maybe one of these days we can even convince them to use a real
> OS like Linux which would save even more. Well, here goes. Have a
> great day! :)
>