Database is actually 2005 SP1 Express...
I'm using the Native client to connect. This is basically a bulk insert operation of 107000 records.
The CursorAdapter uses a lot of the defaults for most properties:
Uses transactions.
Has a key, but the key isn't being updated (UniqueIDentifier to be the default of NewID())
Refreshes all fields after the insert
I'm still learning VFP 9 so there's probably something I'm missing that's new.
On the contrary, the Remote view I built after the Adapter didn't work did the trick. So what has caused the adapter to fail?
Richard
State of Florida, DCF