No Naomi, you are a genius. I think I had a minor typo; I hate to say it but I think I mistype something. I couldn't show the precise path because it is extremely proprietary, but when I went back and looked at the path, I thought I should copy it from the address bar of windows explorer which I did. Once I did that, surprisingly, it worked fine. I still didn't see any difference in the path. It was a longer path than what I showed you.
I just thank you for bearing with me, but I feel bad that you may have wasted your time on my mistake. But, I do appreciate you and all those who tried to help me. It eventually succeeded a few minutes ago.
>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.