Hi Rob,

I dont think i really understand ur problem...
But if ur problem is getting data from a field in a access database, i have an answer for u

1st. Create a a connection in ur vfp database for ur access database
2nd. Create a remote view with the fields u want to get data.
3rd. If u want to save data in ur acces table, just go in ur remote view to the update criteria tab and select ur index and the fields u want to save, then click on the Send SQL Updates check box.

Now if everything works fine u got a vfp connection to ur access database.

Now the prg code:

USE IN 0 ALIAS ltSourceTable
USE >vfptable> IN 0 ALIAS ltTargetTable

SET MULTILOCKS ON
CURSORSETPROP( "Buffering", 3, "ltTargetTable" )
SELECT("ltSourceTable")
GO TOP
SCATTER NAME lotmp

SELECT("ltTargetTable")
APPEND BLANK
GATHER NAME lotmp
TABLEUPDATE(.T.)



IF is not what u want please give-me a better description and i´ll try to help u out...

CYA L8R
Ricardo Martins