*-- build connection string lcConnectionStr = "DRIVER={Microsoft Access Driver (*.mdb)};" +; "Dbq=c:\temp\northwind.mdb;" +; "Uid=Admin;" +; "Pwd=;" *-- connect to Access database lnAccess = SQLSTRINGCONNECT(lcConnectionStr) *-- add a record to the customers table ?SQLEXEC(lnAccess, "INSERT INTO customers (customerId, companyName) VALUES('X0001', 'Customer added through VFP')") *-- or using memvars: m.customerId = "X0002" m.companyName = "Another Customer added through VFP" ?SQLEXEC(lnAccess, "INSERT INTO customers (customerId, companyName) VALUES('" + m.customerId +"', '" + m.companyname + "')")HTH