>Hi,
>
>Can any one help me with code snippet to connect to a local Access Database through VFP?
>
>TIA.

Sony,
Check FAQ #8039
Basically you create a connection and then use SPT. ie:(extracted from FAQ)

lcDataBaseName = 'MSDN'
lcMDBDir = 'C:\My Documents\MSDN CD SUBCRIPTION INDEXES\UN-SUPPED'
lcMDBName = 'MSDN APRIL CD SUBCRIPTION INDEX.MDB'
lnConnHandle = SQLSTRINGCONNECT('DSN=MS Access Database;DBQ='+;
  lcMDBDir+'\'+lcMDBName+';DefaultDir='+;
  lcMDBDir+';DriverId=25;FIL=MS Access;MaxBufferSize=2048;'+;
  'PageTimeout=5;UID=admin;')

SQLExec(lnConnHandle, 'SomeSQLCommandHere')
SQLDisconnect(lnConnHandle)

Cetin