MS Acces needs unique index on table to able edit it. Do
you have Recognize unique indexes enabled on ODBC
driver settings ?. More in FAQ on
http://odbc.postgresql.org/ .
Tomas
> could this be related to me not being able to edit tables in access? i
> have this wierd issue w/ access 2000 wher i can't edit the tables at all..
> but odbc isn't read only .. and works properly.. i checked it w/ an oracle
> odbc test tool and pgadmin.. ??
>
> On Mon, 28 May 2001, Tomas Fulajtar wrote:
>
> > Hello,
> > msysconf is a table which sets optimization for
> > communication between Access and SQL server. You
> > can find more in MS Acces Help - search string
> > msysconf.
> >
> > Tomas Fulajtar
> >
> > > why do i get
> > >
> > > ERROR: Relation 'msysconf' does not exist
> > >
> > > when connecting to an empty database via odbc? just curious .. i'm rather
> > > new to the postgres + odbc world
> > >
> > > -j
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 5: Have you checked our extensive FAQ?
> > >
> > > http://www.postgresql.org/users-lounge/docs/faq.html
> > >
> >
> >
> > ---------------------------------------------
> > Ing. Tomas Fulajtar
> > MORAVIAPRESS, a.s.
> > U pony 3061
> > 690 02 Breclav
> > tel.: 0627/305 216
> >
> > E-mail: tomas.fulajtar@moraviapress.cz
> > WWW: www.moraviapress.cz
> > ---------------------------------------------
> > P.S.:Please use pure ASCII or ISO-8859-2 code
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
