🚀 go-pugleaf

PS. I've narrowed the problem down some. I open several tables at the
begining of the program. Most of the tables use client side cursors but not
all. If I open a particular table with a server side cursor it destroyes the
ability of all the client side tables to resync properly. If  I open this
table with a client side cursor there is no problem. This program runs fine
in Access JET 4.0. The problem only occurs with SQLOLEDB.1

"Tony" <hse@hill-soft.com> wrote in message news:3c80b3af_2@dnews...
> I convertied an Access 2000 db to MS-SQL server and now the ADO dynamic
> property "update resync" does not work. If I set adResyncAutoIncrement,
the
> auto inc ID fields contain 0 in the after post event. If I set
> adResyncInserts, the record disapears from the record set when posted and
> does not re-appear unless you close/open the recordset. This is true for
all
> tables in the database. I have another MS-SQL database on the same machine
> and same server that works fine. Thanks for any help.
>
>
>