cool... that did it... now is there anyway to edit the table structure
from within access?
-j
On Tue, 29 May 2001, Tomas Fulajtar wrote:
> 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
> >
>
>
>