>Does anybody have experience of opening a passworded Access database in VFP to allow my application to import the data? Any feedback much appreciated.
Check faq#8039
This is extracted from there :
lcMDBDir = < DirectoryOfMDB >
lcMDBName = < FileNameOfMDB >
lnConnHandle = SQLSTRINGCONNECT('DSN=MS Access Database;DBQ='+;
lcMDBDir+'\'+lcMDBName+';DefaultDir='+;
lcMDBDir+';FIL=MS Access;UID=< userid >;PWD=< password >;')
? lnConnHandle
lcSQL = 'select * from < TableName >'
SQLEXEC(lnConnHandle,lcSQL,'myCursor')
SQLDISCONNECT(lnConnHandle)
Select myCursor
browCetin
