>Hi,
>
>I have developed in VFP for a number of years and I'm fairly new to VB and ADO, specifically ADODB.
>
>I'm familiar with the syntax to open recordsets, etc, etc.
>
>With VFP, I'm used to using the REPLACE ALL command in a number of my apps. These are apps in which data is imported from mainframe apps and I was wondering if there is a similiar way to do this using ADO and an ACCESS database?

No there isn't.

You need to execute and SQL query like "Update Table1 set F1 = 'NewValue'". You can execute with the Execute method of the connection object.