Hi,
The database on MS-Access is kept on one machine and i have to access it from another machine.. I have given the following connection string on the client machine. But still it is not accessible.
I have shared to Databse folder with full permissions...
But, still it is not accessible.. so what can i do.
public static string con = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\192.168.1.90\D:\Hospital Managment System\Database\HospitalMgt.mdb";
Regards,
Shailaja
Loading
Roei BarPosted Oct 12, 2009, 5:32 AM
Shailaja MohitePosted Oct 12, 2009, 6:10 AM
Shailaja MohitePosted Oct 12, 2009, 5:20 AM
I Give permission to database folder
how to add that folder as a mapped drive
Roei BarPosted Oct 12, 2009, 5:06 AM
in order to be able to do what you need you will need to create a shared folder grant permissions to it
and add that folder as a mapped drive
then you can put that folder in the connection string, and this will work
highly recommend to relocate to SQL Express, much better in performance, maintenance and Lan Connectivity