From: | Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Re: Access 2000 - ADO |
Date: | 2001-04-24 04:50:56 |
Message-ID: | 4.2.0.58.20010424065051.00a7a600@pop.freesurf.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-04-24 05:18:45 | Re: A proposal to change psqlodbc |
Previous Message | Bruce Momjian | 2001-04-24 04:44:51 | Re: A proposal to change psqlodbc |