Problem connecting to Access on network drive.

[Brent]

Sorry if this is completely newbie, I haven't used Access in a while as my
database.
When I do this it works fine,
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +

@"Data Source=C:\db2.mdb");

But if I move the same access file to my network drive, it gives me an
invalid path error.
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +

@"Data Source=I:\db2.mdb");

'I:\db2.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.

This is all running on my local machine. I've tried using the UNC path also,
no luck. Please help.

[Steve C. Orr [MVP, MCSD]]

Most likely the default ASPNET user account does not have network security
privileges.
To test this theory, use impersonation to have the web application run under
your user account.
Here's more info:
http://msdn.microsoft.com/library/de...ersonation.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Brent" <[e-mail]> wrote in message
news:10*************@corp.supernews.com...

Sorry if this is completely newbie, I haven't used Access in a while as my
database.
When I do this it works fine,
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +

@"Data Source=C:\db2.mdb");

But if I move the same access file to my network drive, it gives me an
invalid path error.
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +

@"Data Source=I:\db2.mdb");

'I:\db2.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.

This is all running on my local machine. I've tried using the UNC path also, no luck. Please help.

[William Ryan eMVP]

Can you do a File.Exists(@"I:\db2.mdb")? What does it return?
"Brent" <[e-mail]> wrote in message
news:10*************@corp.supernews.com...

Sorry if this is completely newbie, I haven't used Access in a while as my
database.
When I do this it works fine,
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +

@"Data Source=C:\db2.mdb");

But if I move the same access file to my network drive, it gives me an
invalid path error.
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +

@"Data Source=I:\db2.mdb");

'I:\db2.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.

This is all running on my local machine. I've tried using the UNC path also, no luck. Please help.