Can only write to root of disk

[Eric J.]

I am having a problem writing to an Access database. It only seems to work if the database is placed in c:\
Retrieving records from it is no problem when it is placed in a subdirectory of mapppath, but writing to it is impossible (unless I put it in c:\).

This is the code that refuses to work:
Dim myConString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & MapPath("db\users.mdb") & ";Jet OLEDB:Database Password=123;"

This is the code that works for me:
Dim myConString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\users.mdb" & ";Jet OLEDB:Database Password=nt2123;"

The mappath dir and the \db dir as well as the database file itself have read and write permissions.

Why does it not work???
--
Eric J. van Dorp
VanDorp Educatief
www.vandorp.net

[Phill. W]

"Eric J." <Er***@discussions.microsoft.com> wrote in message
news:86**********************************@microsof t.com...
.. . .

This is the code that refuses to work:
Dim myConString As String _
= "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & MapPath("db\users.mdb") & ";" _
& "Jet OLEDB:Database Password=123;"
Looks like you're written your own MapPath function (usually
provided by the Server object?) or you have On Error Resume Next
work against you.

Perhaps this might work better :
Dim myConString As String _
= "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & Server.MapPath("/db/users.mdb") & ";" _
& "Jet OLEDB:Database Password=123;"

HTH,
Phill W.

[Jos]

Phill. W wrote:

"Eric J." <Er***@discussions.microsoft.com> wrote in message
news:86**********************************@microsof t.com...
. . .

This is the code that refuses to work:
Dim myConString As String _
= "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & MapPath("db\users.mdb") & ";" _
& "Jet OLEDB:Database Password=123;"

Looks like you're written your own MapPath function (usually
provided by the Server object?) or you have On Error Resume Next
work against you.

Perhaps this might work better :

Dim myConString As String _
= "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & Server.MapPath("/db/users.mdb") & ";" _
& "Jet OLEDB:Database Password=123;"

HTH,
Phill W.

MapPath() is also a method of the Page object.

--

Jos

[Cowboy \(Gregory A. Beamer\) [MVP]]

In addition to the suggestion you have already received in this group,
your ASPNET account may not have access to this folder. If the users are
able to access the folder, consider forcing authentication and using
impersonation. If not, you will have to give ASPNET access to the /db
folder.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"Eric J." <Er***@discussions.microsoft.com> wrote in message
news:86**********************************@microsof t.com...

I am having a problem writing to an Access database. It only seems to work if the database is placed in c:\ Retrieving records from it is no problem when it is placed in a subdirectory of mapppath, but writing to it is impossible (unless I put it
in c:\).
This is the code that refuses to work:
Dim myConString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & MapPath("db\users.mdb") & ";Jet OLEDB:Database Password=123;"
This is the code that works for me:
Dim myConString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\users.mdb" & ";Jet OLEDB:Database Password=nt2123;"
The mappath dir and the \db dir as well as the database file itself have read and write permissions.
Why does it not work???
--
Eric J. van Dorp
VanDorp Educatief
www.vandorp.net

[Cowboy \(Gregory A. Beamer\) [MVP]]

Using XP, I take it.

By default, you do not have a security tab in XP. To turn this on, the drive
must be NTFS (if I remember correctly). Go to Windows Explorer and use Tools

Folder Options >> View. Now uncheck "Use Simple File Sharing". You should

now be able to set security correctly to allow ASPNET to work with it.

Since this is the ASP .NET group, I assume you are not using XP Home, which
does not allow you to turn off Simple File Sharing (perhaps a registry
hack?).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"Eric J." <Er***@discussions.microsoft.com> wrote in message
news:5E**********************************@microsof t.com...

In addition to the suggestion you have already received in this group,
your ASPNET account may not have access to this folder. If the users are
able to access the folder, consider forcing authentication and using
impersonation. If not, you will have to give ASPNET access to the /db
folder.
I have set verification to Anonymous (IUSR) and read/write to true in the

ISS system tool. I have given read/write access to all users via the
security tab in Explorer. I only can't set the ' Read Only checkbox' in the
properties of the folder to False. It keeps changing back to True.
I have no idea how to move on from this.

[Eric J.]

> Using XP, I take it.

Yes, indeed

By default, you do not have a security tab in XP. To turn this on, the drive
must be NTFS (if I remember correctly). Go to Windows Explorer and use Tools

Folder Options >> View. Now uncheck "Use Simple File Sharing". You should

now be able to set security correctly to allow ASPNET to work with it.

Since this is the ASP .NET group, I assume you are not using XP Home, which
does not allow you to turn off Simple File Sharing (perhaps a registry
hack?).

No, XP Pro. I did all that. Gave read/write permission to everyone. Still no succes. If I change the connection string to the specified folder it works also ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Totaal\db\users.mdb;Jet OLEDB:Database Password=2123). Just not when I am referring to the folder using MapPath. (DataSource=" & MapPath("db\users.mdb")

[Eric J.]

Found it!!

Changing to
Dim myConString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & Server.MapPath("/db/users.mdb") & ";" _
& "Jet OLEDB:Database Password=123;"

does the trick. Thank you Phil and the rest. Why can't MS produce some better error messages...?