Thread: [ODBC] Driver issue ? Default value not recognized in access

ENGIE Mail Disclaimer: http://www.engie.com/disclaimer/disclaimer-fr.html

On 01/16/2017 02:49 AM, patrick.le-calvez@engie.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.le-calvez@engie.com <mailto:patrick.le-calvez@engie.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.klaver@aklaver.com

ENGIE Mail Disclaimer: http://www.engie.com/disclaimer/disclaimer-fr.html

On 01/17/2017 07:39 AM, patrick.le-calvez@engie.com wrote:
> 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.
>
>
>
> Here are the parameters of the connection.
>
>
>
>
>
>
>
> 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 :


 From what I can gather Access does not pull in the default values from
linked tables. The default value in the table description is something
you have to fill in yourself and is applicable only to Access itself.

>
>
>
> 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.

I do not use VBA so I will not be of much help there. All I can do is
point at:

https://msdn.microsoft.com/en-us/library/ms711683(v=vs.85).aspx

where there is:

COLUMN_DEF (ODBC 3.0) 13  Varchar


The default value of the column. The value in this column should be
interpreted as a string if it is enclosed in quotation marks.

More digging found this:

http://www.techrepublic.com/article/much-ado-about-field-properties/

Not sure if that will help or not.

>
>
>
>
>
> Have a good day,
>
>
>
> Patrick
>
>
>
>
>
>
>



--
Adrian Klaver
adrian.klaver@aklaver.com