Hi All

I have done some reading, and so far all the errors related to my question deal with not being able to open the MDB Database for reading. The solution being (in most cases) allow access to ASPNET.

My issue is even more fundamental than that. I am using an OleDBConnection object which I have placed on my form. I have selected Microsoft Jet 4.0... as the provider. I have pointed to my file and established a connection to it. (Through the properties page)

However when I run the page and attempt to open the connection I get an exception that reads.

'F:\Inetpub\wwwroot\StatusReports\Data\sr.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. (The path is correct, so that is not the actual issue)

Note: my project resides on our Development IIS server, I have IIS loaded on my Windows 2000 workstation, but currently have it disabled. I have attempted to use \\Servername\... instead of F:\ however it doesn't like that any better.

I originally thought that the path to the file would be relative to the project folder. It seems odd to be using the fully realized drive path name. I have noticed in the other questions posted in this forum, that people have used the local "C:\inetpub\wwwroot\projectfolder\file.mdb" so it appears this is the correct format.

Furthermore, what happens when someone else opens this page (once the database can be connected to). They are not likely to even have a connection to this server let alone use the same Drive letter. This is a little confusing.