Thread: Re: Access 2000 - ADO

Re: Access 2000 - ADO

From
Hiroshi Inoue
Date:
B&L: Oliver Br\xF6ker 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