>Naomi,
>
>Are you talking about this string?
>
>

>lcMDBDir  = "C:\Program Files\Star"
>lcMDB     = "The.MDB"  && Example only.
>lnConnHandle = ;
>	SQLSTRINGCONNECT('Driver={Microsoft Access Driver *.mdb};DBQ="'+;
>	lcMDBDir+'\'+lcMDBName+'";UID=admin;Pwd=;')
>

>
>I tried this string also and same problem. "Not valid file."

I guess it's a really bad file then. We were driving you in the wrong direction.

I've tried

lcMDBPath  = "C:\Program Files\Microsoft Office\Office\1033\FPNWIND.MDB"
lnConn =  SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=' + lcMDBPath + ';Exclusive=1;Uid=admin;Pwd=')
=MESSAGEBOX(lnConn)
?SQLEXEC(lnConn,'select * from Customers','crsTest')

and it worked just fine.