Thanks lads for all your help.
Regards,
Gerard


>>Hi.
>>I have Sql express loaded on a server.
>>In Sql Express Management Studio, I can see all tables fine.
>>IN VFP when I use following connection sring:
>> MyConn = 'Driver=SQL; Server = .\sqlexpress;Database = D:\Myfolder\MyDatabase; Trusted_Connection = yes'
>>
>>I get following error:
>>Acces to selected database has been denied
>>Sql SErver error 4060
>>I am loged in as administrator
>>I have enabled all protocols for Sql Express.
>>
>>Anybody got any ideas ??
>>
>>Regards,
>>Gerard
>
>Driver=SQL Native Client
>Database=MyDatabase
>
>or if you need the path and filename as in your sample:
>
>AttachDbFileName=D:\Myfolder\MyDatabase.mdf;Database=myDatabase
>
>PS: Do not use extra spaces around = while writing the connection string.
>Cetin