Re: Driver issue ? Default value not recognized in access

Hello,

Thanks for your answer,

Here are the elements you asked :

1) How is the table in Access linked to the Postgres database?

I create tables linked through a ODBC connection.

[cid:image001(dot)png(at)01D270E0(dot)340454D0]

Here are the parameters of the connection.

[cid:image002(dot)png(at)01D270E0(dot)340454D0]

2) Where do you except the default value to show up?

I expect the default value to appear in 2 places.

First, I would like to see it there :

[cid:image003(dot)png(at)01D270E0(dot)340454D0]

Second (and most of all), when I run my vba subs, I need to use the default values of some fields. At this state, vba does see any.

3) Is the default value created in the database when you INSERT a value without specifying it?

Yes it is.

More specifically, most of my records are inserted via a vba sub. That's where I need those default values the most.

Have a good day,

Patrick

-----Message d'origine-----
De : Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Envoyé : mardi 17 janvier 2017 01:34
À : Le Calvez Patrick (INEO INFRACOM); pgsql-odbc(at)postgresql(dot)org
Objet : Re: [ODBC] Driver issue ? Default value not recognized in access

On 01/16/2017 02:49 AM, patrick(dot)le-calvez(at)engie(dot)com<mailto:patrick(dot)le-calvez(at)engie(dot)com> wrote:

> Hello,

>

>

>

> I've installed a few weeks back a driver obdc, linking my access file

> to my postgresql database.

>

> Thank you for that.

>

> psqlodbc_09_05_0300-x64.zip

>

>

>

> I've a problem, and I think maybe it's within the driver.

>

>

>

> Access doesn't recognize the default values registered in my postgre

> database.

You are going to need to be more specific about this:

1) How is the table in Access linked to the Postgres database?

2) Where do you except the default value to show up?

3) Is the default value created in the database when you INSERT a value without specifying it?

>

> Do you have any intel about that issue ?

>

> Do you anyway to solve it ? Or another way to pass over it ?

>

>

>

> Thanks in advance,

>

>

>

> *Patrick LE CALVEZ*

> *Chef de projet*

>

> *Agence Nord-Est*

>

> *INEO INFRACOM*

>

> _patrick(dot)le-calvez(at)engie(dot)com<mailto:_patrick(dot)le-calvez(at)engie(dot)com> <mailto:patrick(dot)le-calvez(at)engie(dot)com>_

>

> Tel. 03 80 73 74 03

>

> Mob. 06 84 85 33 13

>

>

>

> Logo <http://cofelyineo-gdfsuez.com/>

>

> Curseur

>

> engie-ineo.fr

>

> *Ineo Infracom*

>

> *5 rue Lavoisier - CS 20089

> 21603 LONGVIC Cedex

>

> **Pensez à l'environnement avant d'imprimer ce message.*

>

>

> Curseur Flux

>

>

>

> ENGIE Mail Disclaimer:

> http://www.engie.com/disclaimer/disclaimer-fr.html

>

--

Adrian Klaver

adrian(dot)klaver(at)aklaver(dot)com<mailto:adrian(dot)klaver(at)aklaver(dot)com>
ENGIE Mail Disclaimer: http://www.engie.com/disclaimer/disclaimer-fr.html