Data Environment Designer (Updating)

[F. O. Greene]

I have used the Data Environment Designer for reporting from an ACCESS database
using both code and the Data Report Designer with no problem.
However, I am now attempting to update the database.

The following is the basic setup:

Provider is: Microsoft OLE DB Provider for ODBC Drivers

The Connection is given Read/Write permision

SOURCE of Data for Command1 is: SELECT * FROM Database

Code extracted from the Form1 is as follows:

DataEnvironment1.rsCommand1.Open
DataEnvironment1.rsCommand1.MoveFirst
DBData = DataEnvironment1.rsCommand1![Selected Data]
'
' Intervening Code
'
DataEnvironment1.rsCommand1![Selected Data] = NewData ' Point of Error
DataEnvironment1.rsCommand1.Update

Error Message: Object or provider is not capable of performing requested
operation

Now, Is it true that changing data in the database cannot be done while using
the data environment or have I failed to set some prameter or failed to provide
some necessary code?

Any assistance will be greatly appreciated.
E-Mail to fgreene2@earthlink.net

Thank You for Your Consideration

[marc]

Try the following settings (Advanced tab of data envirnmoent properties):

Cursor Location: 2 - use server
Cursor Type: 1 - Keyset
Lock Type: Anything but readonly

This should work.

Marc


"F. O. Greene" <fgreene2@earthlink.net> wrote:
>
>I have used the Data Environment Designer for reporting from an ACCESS
database
>using both code and the Data Report Designer with no problem.
>However, I am now attempting to update the database.
>
>The following is the basic setup:
>
>Provider is: Microsoft OLE DB Provider for ODBC Drivers
>
>The Connection is given Read/Write permision
>
>SOURCE of Data for Command1 is: SELECT * FROM Database
>
>Code extracted from the Form1 is as follows:
>
>DataEnvironment1.rsCommand1.Open
>DataEnvironment1.rsCommand1.MoveFirst
>DBData = DataEnvironment1.rsCommand1![Selected Data]
>'
>' Intervening Code
>'
>DataEnvironment1.rsCommand1![Selected Data] = NewData ' Point of Error
>DataEnvironment1.rsCommand1.Update
>
>Error Message: Object or provider is not capable of performing requested
>operation
>
>Now, Is it true that changing data in the database cannot be done while
using
>the data environment or have I failed to set some prameter or failed to
provide
>some necessary code?
>
>Any assistance will be greatly appreciated.
>E-Mail to fgreene2@earthlink.net
>
>Thank You for Your Consideration
>
>
>
>

[fgreene]

"marc" <whale@ultranet.com> wrote:
>
>Try the following settings (Advanced tab of data envirnmoent properties):
>
>Cursor Location: 2 - use server
>Cursor Type: 1 - Keyset
>Lock Type: Anything but readonly
>
>This should work.
>
>Marc
>
>
>"F. O. Greene" <fgreene2@earthlink.net> wrote:
>>
>>I have used the Data Environment Designer for reporting from an ACCESS
>database
>>using both code and the Data Report Designer with no problem.
>>However, I am now attempting to update the database.
>>
>>The following is the basic setup:
>>
>>Provider is: Microsoft OLE DB Provider for ODBC Drivers
>>
>>The Connection is given Read/Write permision
>>
>>SOURCE of Data for Command1 is: SELECT * FROM Database
>>
>>Code extracted from the Form1 is as follows:
>>
>>DataEnvironment1.rsCommand1.Open
>>DataEnvironment1.rsCommand1.MoveFirst
>>DBData = DataEnvironment1.rsCommand1![Selected Data]
>>'
>>' Intervening Code
>>'
>>DataEnvironment1.rsCommand1![Selected Data] = NewData ' Point of Error
>>DataEnvironment1.rsCommand1.Update
>>
>>Error Message: Object or provider is not capable of performing requested
>>operation
>>
>>Now, Is it true that changing data in the database cannot be done while
>using
>>the data environment or have I failed to set some prameter or failed to
>provide
>>some necessary code?
>>
>>Any assistance will be greatly appreciated.
>>E-Mail to fgreene2@earthlink.net
>>
>>Thank You for Your Consideration
>>
>>
>>
>>
>

[fgreene]

Works great!
Thank You.

"marc" <whale@ultranet.com> wrote:
>
>Try the following settings (Advanced tab of data envirnmoent properties):
>
>Cursor Location: 2 - use server
>Cursor Type: 1 - Keyset
>Lock Type: Anything but readonly
>
>This should work.
>
>Marc
>
>
>"F. O. Greene" <fgreene2@earthlink.net> wrote:
>>
>>I have used the Data Environment Designer for reporting from an ACCESS
>database
>>using both code and the Data Report Designer with no problem.
>>However, I am now attempting to update the database.
>>
>>The following is the basic setup:
>>
>>Provider is: Microsoft OLE DB Provider for ODBC Drivers
>>
>>The Connection is given Read/Write permision
>>
>>SOURCE of Data for Command1 is: SELECT * FROM Database
>>
>>Code extracted from the Form1 is as follows:
>>
>>DataEnvironment1.rsCommand1.Open
>>DataEnvironment1.rsCommand1.MoveFirst
>>DBData = DataEnvironment1.rsCommand1![Selected Data]
>>'
>>' Intervening Code
>>'
>>DataEnvironment1.rsCommand1![Selected Data] = NewData ' Point of Error
>>DataEnvironment1.rsCommand1.Update
>>
>>Error Message: Object or provider is not capable of performing requested
>>operation
>>
>>Now, Is it true that changing data in the database cannot be done while
>using
>>the data environment or have I failed to set some prameter or failed to
>provide
>>some necessary code?
>>
>>Any assistance will be greatly appreciated.
>>E-Mail to fgreene2@earthlink.net
>>
>>Thank You for Your Consideration
>>
>>
>>
>>
>