lcConnectionStr = "DRIVER={Microsoft Access Driver (*.mdb)};" +; "Dbq=c:\temp\northwind.mdb;" +; "Uid=Admin;" +; "Pwd=;" lnAccess = SQLSTRINGCONNECT(lcConnectionStr) ?SQLEXEC(lnAccess, "SELECT customerId, companyName FROM customers", "Customers")If you want to update the Access data, you can make the SPT cursor updatable by setting the following properties:
CURSORSETPROP("Tables", ["customers"]) CURSORSETPROP("UpdateNameList", [customerid "customers"."CustomerID", companyname "customers"."CompanyName"]) CURSORSETPROP("KeyFieldList", [customerid]) CURSORSETPROP("UpdatableFieldList", [customerid,companyname]) CURSORSETPROP("SendUpdates", .t.)HTH