Hi Paul,
>
>Got a question about access. I am working at a place that has a few access apps they use and I'd like to convert one to VFP. Im sure someone has done this before and would like to get any ideas or possible problems I may encounter or how best to tackle converting access to Foxpro. Such as DB conversion and reports etc..
>
Here we go:

*-- build connection string
lcConnectionStr = "DRIVER={Microsoft Access Driver (*.mdb)};" +;
	"Dbq=C:\mydbcfolder\test_db1.mdb;" +;
	"Uid=Admin;" +;
	"Pwd=;"

*-- connect to Access database
lnAccess = SQLSTRINGCONNECT(lcConnectionStr)

*-- retrieve one table named myclients.. SQLRESULT will be the cursor with the result
?SQLEXEC(lnAccess, "select * from myclients")

return

HTH

Claudio