I have an application that accesses an MS Access (Office 97) database.

Differerent Recordsets may be selected by clicking on a menu item. I can scroll through them with out any problems...and they do contain the right amount of records no matter which one I select.

My problem is that I cannot update any of them....if I try I get the error above....I think I've tried everything to overcome it....

Is there some property or something else missing that I should declare that would give me such an error?

The cursortype is fine. First thing I checked.

I put some debugging code in the WillChangeRecord section and I discovered that only one record seems to be coming through since myRS.Recordcount is = to 1. Yet just before I enter that Sub my RecordCount is 13.

I am using the ADO Data Control and I used the wizard to add some of the base code. Since then I've been using the DE a bit more and I have some recordsets that I am accessing using strictly the DE.

I checked on the length of a kind of duplicate RS created with the DE (deMyDE.rsMyRS) inside of the WillChangeRecord and it correctly reports that my RecordCount is 13.

Do I even need this ADO Control? Can I just add some buttons which do deMyDE.rsMyRS.movenext, etc...?

Do I need all that code in WillChangeRecord, etc... added by the wizard?

I am getting frustrated with this thing....

Here's another twist...the table that I am accessing is an MS Access SYNCHRONIZED database. It worked fine before I started changing the RS on the fly but now that I have given the users the ability to select different records they can no longer update the database.

Can anyone help me here?

Posted via: http://www.*-*-*.com/
Currently with 459,840 posts.
Tired of checking for replies. We'll track them for you.
Win Prizes.

I have an application that accesses an MS Access (Office 97) database.

Differerent Recordsets may be selected by clicking on a menu item. I can scroll through them with out any problems...and they do contain the right amount of records no matter which one I select.

My problem is that I cannot update any of them....if I try I get the error above....I think I've tried everything to overcome it....

Is there some property or something else missing that I should declare that would give me such an error?

The cursortype is fine. First thing I checked.

I put some debugging code in the WillChangeRecord section and I discovered that only one record seems to be coming through since myRS.Recordcount is = to 1. Yet just before I enter that Sub my RecordCount is 13.

I am using the ADO Data Control and I used the wizard to add some of the base code. Since then I've been using the DE a bit more and I have some recordsets that I am accessing using strictly the DE.

I checked on the length of a kind of duplicate RS created with the DE (deMyDE.rsMyRS) inside of the WillChangeRecord and it correctly reports that my RecordCount is 13.

Do I even need this ADO Control? Can I just add some buttons which do deMyDE.rsMyRS.movenext, etc...?

Do I need all that code in WillChangeRecord, etc... added by the wizard?

I am getting frustrated with this thing....

Here's another twist...the table that I am accessing is an MS Access SYNCHRONIZED database. It worked fine before I started changing the RS on the fly but now that I have given the users the ability to select different records they can no longer update the database.

Can anyone help me here?

Posted via: http://forums.webf1.com
Currently with 459,849 posts.
Tired of checking for replies. We'll track them for you.
Win Prizes.