Re: ODBC & Access [Try 2]

> -----Original Message-----
> From: Jeff Eckermann [mailto:jeff_eckermann(at)yahoo(dot)com]
> Sent: Thursday, April 24, 2003 12:08 PM
> To: David Olbersen; pgsql-novice(at)postgresql(dot)org
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] ODBC & Access [Try 2]
>
> <guess>
> Make sure driver option "row versioning" is checked.
> Also, make sure that the offending table has a primary
> key that Access is recognizing as such.
> </guess>
> If both of those conditions are met, and you still
> have a problem, please post your driver settings.

Turned on row versioning, no change.

When I link the table, Access doesn't ask me to chose the primary key. When I look at the Design View for that table it's chosen a primary key. The field it's chosen doesn't have any NULL values and all the rows for that field are unique, so it should be OK, right? The column that it chose is NOT a numeric field, but text. Would that cause a problem?

Driver settings:
================
This is a System DSN.

Datasource options (page 1)
Disable Genetic Optimizer = Checked
KSQO = Checked
Recognize Unique Indexes = Checked
Use Declare/Fetch = Checked
CommLog = Checked
Parse Statements = UNchecked
Cancel as FreeStmt = UNchecked
MyLog = Checked
Unknown Sizes = Maximum
Data Type Options:
Text as LongVarChar = Checked
Unknowns as LongVarChar = UNchecked
Bools as Char = Checked
Miscellanous:
Max Varchar = 254
Max LongVarChar = 8190
Cache Size = 100
SysTable Prefixes = dd_;

Datasource options (page 2)
Read Only = UNchecked
Show System Tables = UNchecked
LF <-> CR/LF conversion = Checked
Updatable Cursors = Checked
Row Versioning = Checked (now, wasn't before)
Disallow Premature = UNchecked
True is -1 = UNchecked
Int8 as = default
Protocol = 7.x,6.4+
OID Options:
Show Column = UNchecked
Connect Settings = <blank>

--------------------------
David Olbersen
iGuard Engineer
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152