Re: Re: Access 2000 - ADO

Hello Oliver,

Microsoft provides an OLEDB extension to allow edition of Access 2000 forms
when used with SQL Server.
ADO forms used with PostgreSQL are read-only. There is no way to change
that at the moment.
See
http://support.microsoft.com/support/kb/articles/Q227/0/53.ASP?LN=EN-US&SD=g
n&FR=0&qry=ado%20forms%20are%20read-only&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=AC
C2000

I use ADO to query my database and linked tables to edit forms.

Greetings from Jean-Michel POURE, Paris, France


At 09:29 24/04/01 +0900, you wrote:
>B&L: Oliver Bröker wrote:
> >
> > Hi !
> >
> > I use Access 2000 as FrontEnd with the newest PGSQL-ODBC-Driver. The
> > connection to PGSQL goes via ADO (not DAO !) directly over IP.
> > SELECT-statements work fine with incredible performance :-)
> >
> > But unfortunately the form in MS-Access are locked, so I am not able to
> > edit data. The tables are not connected via "MS-Access-Tables". I use
> > directly the ODBC-Driver. The Microsoft-Documentation said: use
> > "uniqueTable" and Client-Cursor. But this does not work (I am sure they
> > know it does not work -> MS-SQL-Server...).
> >
>
>Did you try to change driver/datasource options ?
>
>regards,
>Hiroshi Inoue
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html