Look at my web site:
www.sevainc.com/Access
This talks about some of the issues I faced with Access97. I had to make
all currency data types a double in version 6.4 of Postgres. In version
6.5, the numeric data type is a much better choice. You will need to
re-establish your links after making data type changes. Access97 remembers
the data types of ODBC connections between sessions. As for primary keys,
both of the following need to be set up:
1) the ODBC driver needs to have the use unique keys option turned
on2) you need to have a unique key index installed on each table.
I have not figured out how to automatically import relationships. I have
found that they are not necessary in most situation so I have chosen to
ignore them.
Thanks, Michael
> -----Original Message-----
> From: Brent Waldrop [SMTP:waldrop_brent@hotmail.com]
> Sent: Sunday, June 13, 1999 2:28 AM
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] odbc?
>
> HI i have a couple of basic and specific questions about odbc access using
> Access 97. First of all, when i try to add a entry in my access database
> that is connected to my posgres database i get an error that says "ERROR:
> parser: attribute 'salary' is of type 'money' but expression is of type
> 'float8' you will need to rewrite or cast the expression how can i fix t
> his
> so that i am able to add entries to the postgres database? I directly
> linked
> these tables with the odbc driver for postgres. Second think is why would
> you ever want to include the OID section...i noticed there is a option to
> include it in the connection options of the ODBC driver and can't see why
> you would want to do this if your keys are set up properly? The next thing
> i
> want to ask is would you evern want to include the pg_* tables in your
> access database? I can't see why you would want to? and the last question
> is...is there anyway to import relationship type of data into access using
> the odbc driver so you don't have to set it up manually through access?
>
> thanks
> Brent
