Access Database File Online
I have a program written in C# on my desktop that uses an Access Database file as a back end. I would like to install that program on computers at other locations and have them be able to access the same (.mdb) file. It seems logical that should be a straightforward matter, so I installed the file in a folder at a website and pointed the connection string path to that location.
I get the following: ERROR: Not a valid file name.
But when I put the file on the desktop......perfect. I do not understand why the location of the file should make a difference. The string that I am using is as follows:
public const string CONNSTR = @"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " +
@"http://www.websiteName.com/FolderName/FileName.mdb";
I have Mahesh Chand's book "ADO.Net in C#", but cannot find a sample issue there.
If there is way to make this work, I would surely appreciate a point in the right direction. Many Thanks, Pat