473,320 Members | 1,920 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem connecting to Access on network drive.

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.
Nov 22 '05 #1
4 4064
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" <b@b.com> 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.

Nov 22 '05 #2
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" <b@b.com> 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.

Nov 22 '05 #3
Can you do a File.Exists(@"I:\db2.mdb")? What does it return?
"Brent" <b@b.com> 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.

Nov 22 '05 #4
Can you do a File.Exists(@"I:\db2.mdb")? What does it return?
"Brent" <b@b.com> 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.

Nov 22 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: WKC | last post by:
Hi guys, I really have a strange problem that I have no where to look for answer. I have a DTS that generate a text file with data queries from sql server 2K then stores it in a local drive. The...
2
by: Brent | last post by:
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...
6
by: Eran Kampf | last post by:
I am trying to dynamically create directories in my ASP.NET application (I am using Server.MapPath("/")+"test" as the folder) and I am getting a DirectoryNotFoundException saying "Could not find a...
2
by: Peter O'Reilly | last post by:
I am experiencing difficulty access a mapped network drive in an ASP.NET application. While using the .Net framework v 1.1 implementation of System.IO.Directory.Exists(), it fails to recognize a...
8
by: Sarah | last post by:
I need to access some data on a server. I can access it directly using UNC (i.e. \\ComputerName\ShareName\Path\FileName) or using a mapped network drive resource (S:\Path\FileName). Here is my...
8
by: Kevin D. | last post by:
Please note, I already posted this on the MySQL official forum, but received no response. I thought I'd try again in another location. My apologies to anyone reading this twice... Despite...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
1
by: IainAXA | last post by:
Hi I am having problems connecting to a MS Access Db from C#. If the app and Db sit on the same drive then there is no problem, however if I move the Db to a seperate network drive I get the...
1
by: JoeyNic | last post by:
I am working on an application where a web service (on the web tier) calls another web/gateway service (on the app tier). This then needs to save a file to a UNC share on a file server in our...
3
by: iheartvba | last post by:
Hi, I have a MS Access Database which connects to a separate MS Access back end. The back end is located on a network drive on a peer-to-peer network, if the computer with the back end or front...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.