Skip site navigation (1) Skip section navigation (2)

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

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: frazelle09(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Is there a gui front end for this wonderful db program which works like MSAccess?
Date: 2006-07-23 21:11:58
Message-ID: 20060723211158.91551.qmail@web31808.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
>> 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



In response to

pgsql-novice by date

Next:From: Fred FrazelleDate: 2006-07-23 21:57:12
Subject: Re: Is there a gui front end for this wonderful db program
Previous:From: Andrew HammondDate: 2006-07-23 21:03:56
Subject: Re: Is there a gui front end for this wonderful db program which works like MSAccess?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group