>>>>>>Thank you, Borislav. Are you saying that the reason I am getting access problem is because the name of the server is incorrect?
>>>>>
>>>>>
>>>>>No, I didn't said that.
>>>>>I just said that if you attached your DBs in SQL Express that is installed as in instance (default SQLXPRESS) tnen you can't connect to your DB.
>>>>>
>>>>>When you run SSMS what you see?
>>>>
>>>>Thank you for clarifying. When I run SSMS I see the database and can open and view tables and data. I think Sergey is right that I didn't install the ODBC driver that causes my problem.
>>>
>>>You didn't install ODBC driver?
>>>Didn't it came pre-installed with Windows? (I mean Driver=SQL Server) not any of the Native clients.
>>
>>Borislav, where do I look on the PC if the ODBC driver is installed? (on Win 7)
>
>
>Control Panel->Administration Tools->Data sources (ODBC)->Drivers
Interesting that on my Win XP computer the SQL Server ODBC driver version is 2000.85.1117.0 (8/4/2004) but on my Windows 7 computer the driver version is 6.01.7600.16385 (7/13/2009). The file name in both cases, however, is the same SQLSRV32.DLL. No wonder, VFP could not connect to the SQL Server on the Win 7 computer.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham