FAQ
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! :)

Search Discussions

  • Andrew Hammond at Jul 23, 2006 at 9:04 pm
    Have you considered using the ODBC driver to plug your access front-end into
    a postgres database?
    On 7/23/06, Fred Frazelle 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! :)
  • Fred Frazelle at Jul 23, 2006 at 9:57 pm
    Andrew Hammond wrote: Have you considered using the ODBC driver to plug your access front-end
    into a postgres database?

    On 7/23/06, Fred Frazelle 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! :)
    Thanks Andrew!

    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
    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.
    Have a great afternoon and thanks again! :-)
  • Richard Broersma Jr at Jul 23, 2006 at 9:12 pm

    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.
    Postgresql doesn't have an automatic ID is the sense that access does. Postgresql uses a datatype
    called serial. It's default value is an automatically generated id. However in access, when a
    new record is "started" before it is inserted into a postgresql table, the automatic ID will
    display as a blank field until you apply the changes. Simply leave the blank field as a blank.
    When you are finished with the new record and commit it the the postgresql table, the next value
    will display.
    Am waiting on OpenOffice to upgrade
    Any ideas?
    How about the odbc drive for postgresql for use with MS Access. Then you can simply link
    postgresql tables into your MS access project.
    see the following link for the driver to download:
    http://pgfoundry.org/projects/psqlodbc/
    http://www.postgresql.org/download/
    Access chokes or coughs at least acouple of times a week
    and they say it's bec. we have too many userstrying to
    access it at once (15 is too many?)
    It depends, MS access does not lock single records it locks 4K page of the table. This page can
    contain many records. So if person a is editing a record close to the one person b want to edit,
    be will be prevented from editing becuase of the page lock.
    For more information see:
    http://www.developer.com/tech/article.php/721911
  • Richard Broersma Jr at Jul 24, 2006 at 1:08 am
    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 aswell.
    Any ideas?

    If odbc is not what you want for ms-access you could use the driver for open office.
    http://dba.openoffice.org/drivers/postgresql/index.html

    Regards,

    Richard Broersma Jr.
  • Fred Frazelle at Jul 25, 2006 at 12:09 am

    Richard Broersma Jr wrote:
    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 aswell.
    Any ideas?

    If odbc is not what you want for ms-access you could use the driver for open office.
    http://dba.openoffice.org/drivers/postgresql/index.html

    Regards,

    Richard Broersma Jr.
    Thanks Richard. i think i need to explain myself a little bit better.
    i´m not looking for a driver to work with Access but with Postgresql.
    i want to get away from Access bec. of the problems we have with it and
    bec. Postgres seems to be so much more robust, scalable? and secure.
    And i guess i´m not looking for a driver per se, but a frontend which
    would give us the funcionality of Access.

    i have tried using the driver for OOo and postgresql, but it still isn´t
    robust enough to allow me to create two tables, link them properly,
    create a query on both, linked tables, and begin inserting data into
    both tables. The following link shows the OOo database developer´s
    request for a programmer to help out

    http://dba.openoffice.org/servlets/ReadMsg?listName=dev&msgNo=2290

    Have a great day! :) P.D. boy i sure hope this comes out in plane text.
  • Richard Broersma Jr at Jul 25, 2006 at 1:25 am

    And i guess i´m not looking for a driver per se, but a frontend which
    would give us the funcionality of Access.
    I understand a what you are looking for a little bit better. That being the case, I think I
    should dispel a notion that I think you have regarding postgresql. In access, you can create two
    tables. You can also create a select query that will join both tables. The following things can
    be achieved in the same way with postgresql as well.

    However the similarities slightly diverge with your next requirement. In postgresql, you can not
    insert a record in to a query view (where the linked tables in the select statement are cascaded
    related insert statements) as ms-access allows you to do.

    This functionality can be achieved by creating a view (i.e. a query stored on the server) and then
    by adding insert, update, and deleted rules to that view; all changes to the views records will
    be directed to the appropriate tables that the view as created from.

    http://www.postgresql.org/docs/8.1/interactive/tutorial-views.html
    http://www.postgresql.org/docs/8.1/interactive/rules-update.html

    Using this functionality, you could bind a form (i.e. like ms-access/odbc or OOO) to this newly
    created view to get the same functionality you would get from an ms-access select query.

    of course, an alternative to creating a view with rules is to use one of the many client interface
    APIs. With these, you could simulate the same functionality using code. This solution requires a
    steeper learning curve however.

    Regards,

    Richard Broersma Jr.
  • Paul Silveira at Jul 25, 2006 at 1:18 am
    You may want to try "PG Lightning Admin". You can get a shareware version
    from their site (like 30 days) and I think that the licensed version is like
    50 bucks.

    It has a form view that you might be able to use. (i only found that
    yesterday. :))
    http://www.nabble.com/user-files/102/FormView1.gif

    It's really meant for Database Administration/Development but has some
    features that are access-like. It even has a query builder (from under the
    Create View component...)

    Anyway's, sorry if this is totally not what you were looking for but wanted
    to forward it along just in case it helped... Check out their website and
    look at the screenshots to see if this would be interesting to you before
    downloading. (that way there isn't one more applicaiton in your
    applicaitons tray. :))

    It would move you away from access and totally into PostgreSQL though
    (albeit, with a 3rd party frontend)...

    -Paul
    --
    View this message in context: http://www.nabble.com/Is-there-a-gui-front-end-for-this-wonderful-db-program-which-works-like-MSAccess--tf1988857.html#a5478375
    Sent from the PostgreSQL - novice forum at Nabble.com.
  • Frazelle09 at Aug 2, 2006 at 3:45 am
    "You may want to try "PG Lightning Admin". You can get a shareware version
    from their site (like 30 days) and I think that the licensed version is like
    50 bucks. "

    Thanks a lot, Paul. i'll try looking into it. The price is just about
    right, too. i think i've seen it before, but perhaps they have improved it.
    Thanks again!
    --
    View this message in context: http://www.nabble.com/Is-there-a-gui-front-end-for-this-wonderful-db-program-which-works-like-MSAccess--tf1988857.html#a5607247
    Sent from the PostgreSQL - novice forum at Nabble.com.
  • Paul Silveira at Aug 3, 2006 at 12:15 am
    No problem. I've actually just downloaded and tried the Navicat version for
    postgres as well. The windows version has a scheduler built in that allows
    you to schedule backups as well. It integrates with the Windows Scheduler
    and is pretty neat.
    --
    View this message in context: http://www.nabble.com/Is-there-a-gui-front-end-for-this-wonderful-db-program-which-works-like-MSAccess--tf1988857.html#a5624804
    Sent from the PostgreSQL - novice forum at Nabble.com.
  • Tom at Jul 25, 2006 at 1:31 am
    Would the kde application kexi help you ?

    tom

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJul 23, '06 at 7:25p
activeAug 3, '06 at 12:15a
posts11
users5
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase