| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
Hi Ed,
No, you don't understand. Your ASP.Net app is running under ONE user account. That's the one that needs the permissions. It is an application, a single process. Understand? -- HTH, Kevin Spencer Microsoft MVP ..Net Developer Sometimes you eat the elephant. Sometimes the elephant eats you. "EdH" <(E-Mail Removed)> wrote in message news  0DFAED3-C1AE-41B2-8A5F-(E-Mail Removed)...> OK thanks. > > I was trying to get a way that my website members could update their > profiles in the database using DRW (as opposed to me having to write the > code). If I have to give everyone admin permissions this may not be the > way > to go. > > I may have to learn asp and/or asp.net coding after all! > Thanks anyway. > EdH > > "Kevin Spencer" wrote: > >> You have to determine the user account under which ASP.net is running. >> This >> can be found in Task Manager or in your machine.config file. Then you >> have >> to grant the necessary file permissions to that user. The file >> permissions >> would be "change" on the folder in which the datbase resides. >> >> -- >> HTH, >> >> Kevin Spencer >> Microsoft MVP >> ..Net Developer >> Sometimes you eat the elephant. >> Sometimes the elephant eats you. >> >> "EdH" <(E-Mail Removed)> wrote in message >> news:896C3C1F-77B9-4239-9369-(E-Mail Removed)... >> > Yes, it is Access. Where do I set the file permissions? >> > >> > Thanks >> > EdH >> > >> > "Kevin Spencer" wrote: >> > >> >> What database are you using? If it is Access, certain file permissions >> >> must >> >> be set to allow the database to be updated (changed). >> >> >> >> -- >> >> HTH, >> >> >> >> Kevin Spencer >> >> Microsoft MVP >> >> ..Net Developer >> >> Sometimes you eat the elephant. >> >> Sometimes the elephant eats you. >> >> >> >> "EdH" <(E-Mail Removed)> wrote in message >> >> news:70BC9B99-6E74-43F2-A9DF-(E-Mail Removed)... >> >> >I have built a very basic asp.net website to interface with a >> >> >database >> >> > following the instructions in the following MS article >> >> > >> >> > http://msdn.microsoft.com/library/de...singDIWwFP.asp >> >> > >> >> > While I can see all three pages (submission, results and edit) I can >> >> > not >> >> > add >> >> > or edit new records. I can see the contents of the dabase in the >> >> > results >> >> > page >> >> > and I can see the contents in the edit page but I cannot edit them. >> >> > I >> >> > get >> >> > a >> >> > message saying that the operation failed. Same thing if I try a new >> >> > entry >> >> > from the submission form. >> >> > >> >> > Any ideas? >> >> > Thanks >> >> > EdH >> >> > >> >> >> >> >> >> >> >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
OK I get it.
But I checked and I do have the right permission. I have administrator permission to: View, add, and change all server content; manage server settings and accounts. That should be enough. Anything else that could be wrong? Remember the website I made only includes the files created in this article: http://msdn.microsoft.com/library/de...singDIWwFP.asp Do those files work or do I need to add anything else to them? Thanks, EdH "Kevin Spencer" wrote: > Hi Ed, > > No, you don't understand. Your ASP.Net app is running under ONE user > account. That's the one that needs the permissions. It is an application, a > single process. Understand? > > -- > HTH, > > Kevin Spencer > Microsoft MVP > ..Net Developer > Sometimes you eat the elephant. > Sometimes the elephant eats you. > > "EdH" <(E-Mail Removed)> wrote in message > news 0DFAED3-C1AE-41B2-8A5F-(E-Mail Removed)...> > OK thanks. > > > > I was trying to get a way that my website members could update their > > profiles in the database using DRW (as opposed to me having to write the > > code). If I have to give everyone admin permissions this may not be the > > way > > to go. > > > > I may have to learn asp and/or asp.net coding after all! > > Thanks anyway. > > EdH > > > > "Kevin Spencer" wrote: > > > >> You have to determine the user account under which ASP.net is running. > >> This > >> can be found in Task Manager or in your machine.config file. Then you > >> have > >> to grant the necessary file permissions to that user. The file > >> permissions > >> would be "change" on the folder in which the datbase resides. > >> > >> -- > >> HTH, > >> > >> Kevin Spencer > >> Microsoft MVP > >> ..Net Developer > >> Sometimes you eat the elephant. > >> Sometimes the elephant eats you. > >> > >> "EdH" <(E-Mail Removed)> wrote in message > >> news:896C3C1F-77B9-4239-9369-(E-Mail Removed)... > >> > Yes, it is Access. Where do I set the file permissions? > >> > > >> > Thanks > >> > EdH > >> > > >> > "Kevin Spencer" wrote: > >> > > >> >> What database are you using? If it is Access, certain file permissions > >> >> must > >> >> be set to allow the database to be updated (changed). > >> >> > >> >> -- > >> >> HTH, > >> >> > >> >> Kevin Spencer > >> >> Microsoft MVP > >> >> ..Net Developer > >> >> Sometimes you eat the elephant. > >> >> Sometimes the elephant eats you. > >> >> > >> >> "EdH" <(E-Mail Removed)> wrote in message > >> >> news:70BC9B99-6E74-43F2-A9DF-(E-Mail Removed)... > >> >> >I have built a very basic asp.net website to interface with a > >> >> >database > >> >> > following the instructions in the following MS article > >> >> > > >> >> > http://msdn.microsoft.com/library/de...singDIWwFP.asp > >> >> > > >> >> > While I can see all three pages (submission, results and edit) I can > >> >> > not > >> >> > add > >> >> > or edit new records. I can see the contents of the dabase in the > >> >> > results > >> >> > page > >> >> > and I can see the contents in the edit page but I cannot edit them. > >> >> > I > >> >> > get > >> >> > a > >> >> > message saying that the operation failed. Same thing if I try a new > >> >> > entry > >> >> > from the submission form. > >> >> > > >> >> > Any ideas? > >> >> > Thanks > >> >> > EdH > >> >> > > >> >> > >> >> > >> >> > >> > >> > >> > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Hi Ed,
You're getting close, but not there yet. It's not YOUR account; it's the account under which the ASP.Net worker process is running. Every application or process on a computer runs under a Windows user account. Which account depends on the process, and affects the priveleges of that process. The ASP.Net worker process is called "aspnet_wp.exe" in Windows XP, and "w3wp.exe" under Windows Server 2003. You can use the Processes tab in Task Manager to see what account that process is running under. -- HTH, Kevin Spencer Microsoft MVP ..Net Developer Sometimes you eat the elephant. Sometimes the elephant eats you. "EdH" <(E-Mail Removed)> wrote in message news:1446EA7E-BAE5-4436-8DB5-(E-Mail Removed)... > OK I get it. > > But I checked and I do have the right permission. I have administrator > permission to: View, add, and change all server content; manage server > settings and accounts. > That should be enough. > > Anything else that could be wrong? Remember the website I made only > includes > the files created in this article: > > http://msdn.microsoft.com/library/de...singDIWwFP.asp > > Do those files work or do I need to add anything else to them? > Thanks, > EdH > > "Kevin Spencer" wrote: > >> Hi Ed, >> >> No, you don't understand. Your ASP.Net app is running under ONE user >> account. That's the one that needs the permissions. It is an application, >> a >> single process. Understand? >> >> -- >> HTH, >> >> Kevin Spencer >> Microsoft MVP >> ..Net Developer >> Sometimes you eat the elephant. >> Sometimes the elephant eats you. >> >> "EdH" <(E-Mail Removed)> wrote in message >> news 0DFAED3-C1AE-41B2-8A5F-(E-Mail Removed)...>> > OK thanks. >> > >> > I was trying to get a way that my website members could update their >> > profiles in the database using DRW (as opposed to me having to write >> > the >> > code). If I have to give everyone admin permissions this may not be the >> > way >> > to go. >> > >> > I may have to learn asp and/or asp.net coding after all! >> > Thanks anyway. >> > EdH >> > >> > "Kevin Spencer" wrote: >> > >> >> You have to determine the user account under which ASP.net is running. >> >> This >> >> can be found in Task Manager or in your machine.config file. Then you >> >> have >> >> to grant the necessary file permissions to that user. The file >> >> permissions >> >> would be "change" on the folder in which the datbase resides. >> >> >> >> -- >> >> HTH, >> >> >> >> Kevin Spencer >> >> Microsoft MVP >> >> ..Net Developer >> >> Sometimes you eat the elephant. >> >> Sometimes the elephant eats you. >> >> >> >> "EdH" <(E-Mail Removed)> wrote in message >> >> news:896C3C1F-77B9-4239-9369-(E-Mail Removed)... >> >> > Yes, it is Access. Where do I set the file permissions? >> >> > >> >> > Thanks >> >> > EdH >> >> > >> >> > "Kevin Spencer" wrote: >> >> > >> >> >> What database are you using? If it is Access, certain file >> >> >> permissions >> >> >> must >> >> >> be set to allow the database to be updated (changed). >> >> >> >> >> >> -- >> >> >> HTH, >> >> >> >> >> >> Kevin Spencer >> >> >> Microsoft MVP >> >> >> ..Net Developer >> >> >> Sometimes you eat the elephant. >> >> >> Sometimes the elephant eats you. >> >> >> >> >> >> "EdH" <(E-Mail Removed)> wrote in message >> >> >> news:70BC9B99-6E74-43F2-A9DF-(E-Mail Removed)... >> >> >> >I have built a very basic asp.net website to interface with a >> >> >> >database >> >> >> > following the instructions in the following MS article >> >> >> > >> >> >> > http://msdn.microsoft.com/library/de...singDIWwFP.asp >> >> >> > >> >> >> > While I can see all three pages (submission, results and edit) I >> >> >> > can >> >> >> > not >> >> >> > add >> >> >> > or edit new records. I can see the contents of the dabase in the >> >> >> > results >> >> >> > page >> >> >> > and I can see the contents in the edit page but I cannot edit >> >> >> > them. >> >> >> > I >> >> >> > get >> >> >> > a >> >> >> > message saying that the operation failed. Same thing if I try a >> >> >> > new >> >> >> > entry >> >> >> > from the submission form. >> >> >> > >> >> >> > Any ideas? >> >> >> > Thanks >> >> >> > EdH >> >> >> > >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
There is only one user and that is the administrator and that is me. I do
think that I have administrator permissions which I know is right because I run another website in that server where I enter data into a database with no problem. The problem I am trying to resolve is how to update data in a database using the DRW instead of having to program code. I don't know asp.net but I am trying the instructions in the MS article I mentioned earlier but it doesn't seem to work. If you assume that the permissions are good. Are the web pages defined in the MS article correct? Do I need to add anything to it to make it work? Thanks again. EdH "Kevin Spencer" wrote: > Hi Ed, > > You're getting close, but not there yet. It's not YOUR account; it's the > account under which the ASP.Net worker process is running. Every application > or process on a computer runs under a Windows user account. Which account > depends on the process, and affects the priveleges of that process. The > ASP.Net worker process is called "aspnet_wp.exe" in Windows XP, and > "w3wp.exe" under Windows Server 2003. You can use the Processes tab in Task > Manager to see what account that process is running under. > > -- > HTH, > > Kevin Spencer > Microsoft MVP > ..Net Developer > Sometimes you eat the elephant. > Sometimes the elephant eats you. > > "EdH" <(E-Mail Removed)> wrote in message > news:1446EA7E-BAE5-4436-8DB5-(E-Mail Removed)... > > OK I get it. > > > > But I checked and I do have the right permission. I have administrator > > permission to: View, add, and change all server content; manage server > > settings and accounts. > > That should be enough. > > > > Anything else that could be wrong? Remember the website I made only > > includes > > the files created in this article: > > > > http://msdn.microsoft.com/library/de...singDIWwFP.asp > > > > Do those files work or do I need to add anything else to them? > > Thanks, > > EdH > > > > "Kevin Spencer" wrote: > > > >> Hi Ed, > >> > >> No, you don't understand. Your ASP.Net app is running under ONE user > >> account. That's the one that needs the permissions. It is an application, > >> a > >> single process. Understand? > >> > >> -- > >> HTH, > >> > >> Kevin Spencer > >> Microsoft MVP > >> ..Net Developer > >> Sometimes you eat the elephant. > >> Sometimes the elephant eats you. > >> > >> "EdH" <(E-Mail Removed)> wrote in message > >> news 0DFAED3-C1AE-41B2-8A5F-(E-Mail Removed)...> >> > OK thanks. > >> > > >> > I was trying to get a way that my website members could update their > >> > profiles in the database using DRW (as opposed to me having to write > >> > the > >> > code). If I have to give everyone admin permissions this may not be the > >> > way > >> > to go. > >> > > >> > I may have to learn asp and/or asp.net coding after all! > >> > Thanks anyway. > >> > EdH > >> > > >> > "Kevin Spencer" wrote: > >> > > >> >> You have to determine the user account under which ASP.net is running. > >> >> This > >> >> can be found in Task Manager or in your machine.config file. Then you > >> >> have > >> >> to grant the necessary file permissions to that user. The file > >> >> permissions > >> >> would be "change" on the folder in which the datbase resides. > >> >> > >> >> -- > >> >> HTH, > >> >> > >> >> Kevin Spencer > >> >> Microsoft MVP > >> >> ..Net Developer > >> >> Sometimes you eat the elephant. > >> >> Sometimes the elephant eats you. > >> >> > >> >> "EdH" <(E-Mail Removed)> wrote in message > >> >> news:896C3C1F-77B9-4239-9369-(E-Mail Removed)... > >> >> > Yes, it is Access. Where do I set the file permissions? > >> >> > > >> >> > Thanks > >> >> > EdH > >> >> > > >> >> > "Kevin Spencer" wrote: > >> >> > > >> >> >> What database are you using? If it is Access, certain file > >> >> >> permissions > >> >> >> must > >> >> >> be set to allow the database to be updated (changed). > >> >> >> > >> >> >> -- > >> >> >> HTH, > >> >> >> > >> >> >> Kevin Spencer > >> >> >> Microsoft MVP > >> >> >> ..Net Developer > >> >> >> Sometimes you eat the elephant. > >> >> >> Sometimes the elephant eats you. > >> >> >> > >> >> >> "EdH" <(E-Mail Removed)> wrote in message > >> >> >> news:70BC9B99-6E74-43F2-A9DF-(E-Mail Removed)... > >> >> >> >I have built a very basic asp.net website to interface with a > >> >> >> >database > >> >> >> > following the instructions in the following MS article > >> >> >> > > >> >> >> > http://msdn.microsoft.com/library/de...singDIWwFP.asp > >> >> >> > > >> >> >> > While I can see all three pages (submission, results and edit) I > >> >> >> > can > >> >> >> > not > >> >> >> > add > >> >> >> > or edit new records. I can see the contents of the dabase in the > >> >> >> > results > >> >> >> > page > >> >> >> > and I can see the contents in the edit page but I cannot edit > >> >> >> > them. > >> >> >> > I > >> >> >> > get > >> >> >> > a > >> >> >> > message saying that the operation failed. Same thing if I try a > >> >> >> > new > >> >> >> > entry > >> >> >> > from the submission form. > >> >> >> > > >> >> >> > Any ideas? > >> >> >> > Thanks > >> >> >> > EdH > >> >> >> > > >> >> >> > >> >> >> > >> >> >> > >> >> > >> >> > >> >> > >> > >> > >> > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Ed,
I can't help you if you don't listen. Your computer has a number of user accounts, among which is yours. For example, there is a System account under which most programs run. Other programs run under a variety of other accounts. You didn't create them, any more than you created the built-in Administrator account. Your operating system did. Yes, you are trying to follow instructions, but you don't understand them, and you've made a mistake somewhere. My mother once told me that people would ask her for her recipes, and then complain that they didn't taste the same as hers. It turns out that they didn't follow her recipe exactly. They'd add a pinch of this here and a dash of that there. What's worse about computers is, everything they do is math. Guess what happens when just one number is wrong in an equation? Now, I make a darn good living as a programmer, and I do some pretty sophisticated stuff for a living. I am the Senior Application Developer for my company. I am currently working on a 3D terrain modeller for small aircraft, which runs off of a GPS, and uses USGS Digital Elevation Model data, USGS National Land Cover data, FAA airport information data, NWS weather data, Microsoft Managed DirectX, and Microsoft Indigo, running on the beta version of the Microsoft .Net 2.0 platform. I'm just telling you this to get you to trust me. I know what I'm talking about. So, when you can snatch this pebble out of my hand, Grasshopper, you will have learned. -- HTH, Kevin Spencer Microsoft MVP ..Net Developer Sometimes you eat the elephant. Sometimes the elephant eats you. "EdH" <(E-Mail Removed)> wrote in message news:66D294C8-CD2D-405C-98A9-(E-Mail Removed)... > There is only one user and that is the administrator and that is me. I do > think that I have administrator permissions which I know is right because > I > run another website in that server where I enter data into a database with > no > problem. > > The problem I am trying to resolve is how to update data in a database > using > the DRW instead of having to program code. I don't know asp.net but I am > trying the instructions in the MS article I mentioned earlier but it > doesn't > seem to work. > > If you assume that the permissions are good. Are the web pages defined in > the MS article correct? Do I need to add anything to it to make it work? > > Thanks again. > EdH > > > "Kevin Spencer" wrote: > >> Hi Ed, >> >> You're getting close, but not there yet. It's not YOUR account; it's the >> account under which the ASP.Net worker process is running. Every >> application >> or process on a computer runs under a Windows user account. Which account >> depends on the process, and affects the priveleges of that process. The >> ASP.Net worker process is called "aspnet_wp.exe" in Windows XP, and >> "w3wp.exe" under Windows Server 2003. You can use the Processes tab in >> Task >> Manager to see what account that process is running under. >> >> -- >> HTH, >> >> Kevin Spencer >> Microsoft MVP >> ..Net Developer >> Sometimes you eat the elephant. >> Sometimes the elephant eats you. >> >> "EdH" <(E-Mail Removed)> wrote in message >> news:1446EA7E-BAE5-4436-8DB5-(E-Mail Removed)... >> > OK I get it. >> > >> > But I checked and I do have the right permission. I have administrator >> > permission to: View, add, and change all server content; manage server >> > settings and accounts. >> > That should be enough. >> > >> > Anything else that could be wrong? Remember the website I made only >> > includes >> > the files created in this article: >> > >> > http://msdn.microsoft.com/library/de...singDIWwFP.asp >> > >> > Do those files work or do I need to add anything else to them? >> > Thanks, >> > EdH >> > >> > "Kevin Spencer" wrote: >> > >> >> Hi Ed, >> >> >> >> No, you don't understand. Your ASP.Net app is running under ONE user >> >> account. That's the one that needs the permissions. It is an >> >> application, >> >> a >> >> single process. Understand? >> >> >> >> -- >> >> HTH, >> >> >> >> Kevin Spencer >> >> Microsoft MVP >> >> ..Net Developer >> >> Sometimes you eat the elephant. >> >> Sometimes the elephant eats you. >> >> >> >> "EdH" <(E-Mail Removed)> wrote in message >> >> news 0DFAED3-C1AE-41B2-8A5F-(E-Mail Removed)...>> >> > OK thanks. >> >> > >> >> > I was trying to get a way that my website members could update their >> >> > profiles in the database using DRW (as opposed to me having to write >> >> > the >> >> > code). If I have to give everyone admin permissions this may not be >> >> > the >> >> > way >> >> > to go. >> >> > >> >> > I may have to learn asp and/or asp.net coding after all! >> >> > Thanks anyway. >> >> > EdH >> >> > >> >> > "Kevin Spencer" wrote: >> >> > >> >> >> You have to determine the user account under which ASP.net is >> >> >> running. >> >> >> This >> >> >> can be found in Task Manager or in your machine.config file. Then >> >> >> you >> >> >> have >> >> >> to grant the necessary file permissions to that user. The file >> >> >> permissions >> >> >> would be "change" on the folder in which the datbase resides. >> >> >> >> >> >> -- >> >> >> HTH, >> >> >> >> >> >> Kevin Spencer >> >> >> Microsoft MVP >> >> >> ..Net Developer >> >> >> Sometimes you eat the elephant. >> >> >> Sometimes the elephant eats you. >> >> >> >> >> >> "EdH" <(E-Mail Removed)> wrote in message >> >> >> news:896C3C1F-77B9-4239-9369-(E-Mail Removed)... >> >> >> > Yes, it is Access. Where do I set the file permissions? >> >> >> > >> >> >> > Thanks >> >> >> > EdH >> >> >> > >> >> >> > "Kevin Spencer" wrote: >> >> >> > >> >> >> >> What database are you using? If it is Access, certain file >> >> >> >> permissions >> >> >> >> must >> >> >> >> be set to allow the database to be updated (changed). >> >> >> >> >> >> >> >> -- >> >> >> >> HTH, >> >> >> >> >> >> >> >> Kevin Spencer >> >> >> >> Microsoft MVP >> >> >> >> ..Net Developer >> >> >> >> Sometimes you eat the elephant. >> >> >> >> Sometimes the elephant eats you. >> >> >> >> >> >> >> >> "EdH" <(E-Mail Removed)> wrote in message >> >> >> >> news:70BC9B99-6E74-43F2-A9DF-(E-Mail Removed)... >> >> >> >> >I have built a very basic asp.net website to interface with a >> >> >> >> >database >> >> >> >> > following the instructions in the following MS article >> >> >> >> > >> >> >> >> > http://msdn.microsoft.com/library/de...singDIWwFP.asp >> >> >> >> > >> >> >> >> > While I can see all three pages (submission, results and edit) >> >> >> >> > I >> >> >> >> > can >> >> >> >> > not >> >> >> >> > add >> >> >> >> > or edit new records. I can see the contents of the dabase in >> >> >> >> > the >> >> >> >> > results >> >> >> >> > page >> >> >> >> > and I can see the contents in the edit page but I cannot edit >> >> >> >> > them. >> >> >> >> > I >> >> >> >> > get >> >> >> >> > a >> >> >> >> > message saying that the operation failed. Same thing if I try >> >> >> >> > a >> >> >> >> > new >> >> >> >> > entry >> >> >> >> > from the submission form. >> >> >> >> > >> >> >> >> > Any ideas? >> >> >> >> > Thanks >> >> >> >> > EdH >> >> >> >> > >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem Opening Multiple Access Databases | JeffTO | Microsoft Access | 2 | 27th Jul 2010 06:44 PM |
| I have a problem with two cross referenced databases | drolfe@nelsonwatson.com | Microsoft Access Database Table Design | 3 | 25th Oct 2006 05:52 PM |
| problem with huge databases in access-XML mentioned | Julie | Microsoft Access | 2 | 31st Jul 2006 07:02 AM |
| Multiple databases logon problem | Lynn | Microsoft Access Security | 1 | 5th Dec 2003 08:05 PM |
| Speed Problem on different databases using ASP.NET | Viktor Elvar | Microsoft ASP .NET | 2 | 7th Jul 2003 01:55 PM |
