David W. Fenton wrote:
RoyVidar wrote in
:

David W. Fenton wrote:
"David W. Fenton" wrote in
36.94:

The Recordset property of a form was introduced
in Access 2000 and is settable to a predefined DAO recordset
(never an ADO recordset, as form recordsets are always DAO).

As I said in another post, this is incorrect. The form's
Recordset property can be set to an ADO recordset, but it will be
read-only.

No, you can very well have updateable forms that are based on ADO
recordsets, except as I stated elsewhere

if you're using Access 2000 AND it's based on Jet data

That's not what MichKa's article says. Did it change after he posted
that? And is this specific to A2K?

I think that when MichKa says

"At present, the ADO recordsets mentioned above will cause the form to
be read-only."

he is pointing to his above bullet point/paragraph were he only talks
about ADO recordsets based on Jet tables. He says nothing about SQL
server.

So - he's specifically talking about ADO recordsets based on Jet data,
and since the article is dated 1/22/00, it means latest version at
that time, was Access 2000.

And this is true, under those circumstances - Access 2000 AND
the ADO recordset is based on Jet data, the form is read-only.

And yes, this changed in the 2002 version of Access, where ADO
recordsets based on different OLEDB providers (SQL Server, Jet,
Oracle and ODBC) could provide updateable form recordsets.

But, as MS says (for 2002 and later versions):
"Requirements for Microsoft Jet
Even though it is possible to bind a form to an ADO recordset that is
using data from a Jet database, Microsoft recommends that you use DAO
instead. DAO is highly optimized for Jet and typically performs faster
than ADO when used with a Jet database.

[snipped some explanations and code sample]

Note that the form is bound to an updateable recordset that is using
Jet data."

http://support.microsoft.com/kb/281998/EN-US/

Also, using MSDataShape and SQL Server OLEDB providers, one can have
updateable forms based on ADO recordsets in the Access 2000 version.

http://support.microsoft.com/kb/227053/EN-US/

--
Roy-Vidar