Hello,
Do you have Keyset Query optimization turned on in the ODBC driver?
Does the table contain a lot of data? It may be that the entire
table is trying to be loaded into the system. Try turning on the FETCH
option.
I must admit I don't tend to use dual field Primary Keys (I tend to
add in a serial field to act as a PK if the it would otherwise be multiple
columns.).
Hope you manage to get it sorted,
- Stuart
> -----Original Message-----
> From: J. 'FIK' Brand [SMTP:jurgen.brand@tip.nl]
> Sent: Friday, June 08, 2001 6:45 AM
> To: pgsql-odbc@postgresql.org; pgsql-interfaces@postgresql.org
> Subject: ODBC+Access2000, Win2k and Win98
>
> I've got a problem with ODBC+Access 2000 on win98, it works on win2k.
>
> In Access I link a table (c0011) when i try to open that table i get a
> error 'Out of mem'. This happens on Win98, on Win2k it works.
>
> There are more tables link and they work, but c0011 is differend because
> it is the only table where the primary key is made of 2 fields.
>
> Configuration :
>
> Server : RedHat 6.2 + Postgresql 7.1.2
>
> Client1 : Win98 se
> Postgresql ODBC 7.01.0005
> MS Office 2000 + SR1 + SR2
>
> Client2 : Win 2000 + SR1
> Postgresql ODBC 7.01.0005
> MS Office 2000 + SR1 + SR2
>
> Table c0011 :
> create table c0011 (
> al_artikelnummer varchar(12),
> al_prioriteit as int,
> al_relatienummer varchar(12),
> al_artnr_lev varchar(15),
> al_inkoopprijs as double,
> primary key (al_artikelnummer, al_prioriteit)
> )
>
>
> Jurgen Brand
> Smits Metalen Ramen