permissions problem

[John]

Hi!
I am writing a application using ASP and MSAccess.
I create a sql query in order to add or drop a field from my db. However,
when I try to execute the sql query through the ASP page (not
MSAccess design view), I get the following message:

"Cannot modify the design of table 'Artemis'. It is in a read-only
database."

Any ideas?
Thnx in advance

[Jeff Cochran]

On Fri, 14 Nov 2003 09:35:20 +0200, "John"
<reply_to_group@stop_spam.com> wrote:

>I am writing a application using ASP and MSAccess.
>I create a sql query in order to add or drop a field from my db. However,
>when I try to execute the sql query through the ASP page (not
>MSAccess design view), I get the following message:
>
>"Cannot modify the design of table 'Artemis'. It is in a read-only
>database."
>
>Any ideas?

Post the entire error message. Also check the permissions for the
IUSR account on the MDB file and the folder it resides in.

Jeff

[John]

Thnx I solve the problem.
I had desactivated the account.


"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:3fb4d78d.1429900688@msnews.microsoft.com...

> On Fri, 14 Nov 2003 09:35:20 +0200, "John"
> <reply_to_group@stop_spam.com> wrote:
>

> >I am writing a application using ASP and MSAccess.
> >I create a sql query in order to add or drop a field from my db. However,
> >when I try to execute the sql query through the ASP page (not
> >MSAccess design view), I get the following message:
> >
> >"Cannot modify the design of table 'Artemis'. It is in a read-only
> >database."
> >
> >Any ideas?

>
> Post the entire error message. Also check the permissions for the
> IUSR account on the MDB file and the folder it resides in.
>
> Jeff

[DC]

I have a permissions situation. I am and old NetWare
guru, and relatively new to the Windows Server 2000/2003
permissions world. This is what I am having a problem
with.

We have a Marketing share on one of our servers that all
users in the Marketing Group have access to. The share
permissions are Read and Change enabled. The security
tab has Read & Execute, List Folder Contents, and Read
rights checked under the same directory Marketing.

Then under the Marketing directory, we have the
BusinessDevelopmentGroup directory, which contains
several subdirectories under this directory. My dilemma
is that I want to give rights to only 2 directories under
this directory. For example, I have directories A thru
Z, but only want to give a few people access to
directories C & D. How then, shall I do this? If I give
people permissions to directories C and D exclusively,
then they have to map directly to these directories which
I don't want to have to add a separate mapping for this
purpose.

Ideally, I would like to give them a mapping to the
Marketing directory, and have them able to see these 2
directories only in the Business Development directory.
Any ideas?

Here is the directory structure:

c:\Marketing ("Share level"- Read and Change
enabled. "NTFS permissions"-Read&Exec,List
FolderContents, Read)
Business Development (no rights have been given
to the users that need access to Directories C and D)
A
B
C (Give access here.)
D (Give access here.)
E

Bottom line: Is there a way to map to the marketing
share/directory and be able to see directories C and D
without the need for specific mapping(s) to directories C
and D?

Thanks!!

[Neal Duitz]

Good Day Friends,

I received my beta kit last night (March 10th) and after a failed upgrade
install decided to go for broke do a clean install, which seemed to work
much better. At any rate, with the exception of the lack of drivers for my
HP Photosmart 7660 printer and my Philips Acoustic Edge Sound Card (PSC 706)
all is going pretty well. However, I seem to have run into a permissions
problem. I have installed Office 2003 and MS Money 2006 and was attempted to
open my existing (Pre Vista) PST and Money files but each time I am denied
access. The system telle me that I may not have permission. I am the only
administrator on my system and have not changed any of the default settings.
Can you advise?

Thanks in Advance,

Neal Duitz

[Zack Whittaker \(R2 Mentor\)]

I can test my new PHP system right now :op I think you need to disable UAP
on your computer. Go here:
[url]http://www.zacknet.co.uk/vistabase/pages.php?subcats/security/whatisuap[/url]

(Now I hope that PHP thing works now... because I spent 3 days trying to
work out how to direct link to my articles!)

--
Zack Whittaker
Microsoft Beta (Windows Server R2 Beta Mentor)
» ZackNET Enterprises: [url]www.zacknet.co.uk[/url]
» MSBlog on ResDev: [url]http://msblog.resdev.net[/url]
» ZackNET Forum: [url]www.zacknet.co.uk/forum[/url]
» VistaBase: [url]www.zacknet.co.uk/vistabase[/url]
» This mailing is provided "as is" with no warranties, and confers no
rights. All opinions expressed are those of myself unless stated so, and not
of my employer, best friend, mother or cat. Let's be clear on that one!


--- Original message follows ---
"Neal Duitz" <nduitz@socal.rr.com> wrote in message
news:138A7E2C-0D03-4BB4-9202-28A1D830B165@microsoft.com...

> Good Day Friends,
>
> I received my beta kit last night (March 10th) and after a failed upgrade
> install decided to go for broke do a clean install, which seemed to work
> much better. At any rate, with the exception of the lack of drivers for my
> HP Photosmart 7660 printer and my Philips Acoustic Edge Sound Card (PSC
> 706) all is going pretty well. However, I seem to have run into a
> permissions problem. I have installed Office 2003 and MS Money 2006 and
> was attempted to open my existing (Pre Vista) PST and Money files but each
> time I am denied access. The system telle me that I may not have
> permission. I am the only administrator on my system and have not changed
> any of the default settings. Can you advise?
>
> Thanks in Advance,
>
> Neal Duitz

[Andre Da Costa [Extended64]]

Try disabling UAP and see if it fixes the issue, Click Start > All Programs

> Accessories > Run > type MSCONFIG > Tools (tab) scroll down > select

Disable UAP > click Launch > OK. Restart the system and try importing the
..pst
--
Andre
Extended64 | [url]http://www.extended64.com[/url]
Blog | [url]http://www.extended64.com/blogs/andre[/url]
[url]http://spaces.msn.com/members/adacosta[/url]
FAQ for MS AntiSpy [url]http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm[/url]

"Neal Duitz" <nduitz@socal.rr.com> wrote in message
news:138A7E2C-0D03-4BB4-9202-28A1D830B165@microsoft.com...

> Good Day Friends,
>
> I received my beta kit last night (March 10th) and after a failed upgrade
> install decided to go for broke do a clean install, which seemed to work
> much better. At any rate, with the exception of the lack of drivers for my
> HP Photosmart 7660 printer and my Philips Acoustic Edge Sound Card (PSC
> 706) all is going pretty well. However, I seem to have run into a
> permissions problem. I have installed Office 2003 and MS Money 2006 and
> was attempted to open my existing (Pre Vista) PST and Money files but each
> time I am denied access. The system telle me that I may not have
> permission. I am the only administrator on my system and have not changed
> any of the default settings. Can you advise?
>
> Thanks in Advance,
>
> Neal Duitz

[Neal Duitz]

Thanks Andre,

That seemed to do the trick. I followed your instructinons and solved the
problems with the two files. One quick follow up. Should I now re enable UAP
or will that cause the problem to reappear?

Thanks Again,

Neal
"Andre Da Costa [Extended64]" <andred25@hotmail.com> wrote in message
news:uKtOYlXRGHA.1688@TK2MSFTNGP11.phx.gbl...

> Try disabling UAP and see if it fixes the issue, Click Start > All
> Programs

> > Accessories > Run > type MSCONFIG > Tools (tab) scroll down > select

> Disable UAP > click Launch > OK. Restart the system and try importing the
> .pst
> --
> Andre
> Extended64 | [url]http://www.extended64.com[/url]
> Blog | [url]http://www.extended64.com/blogs/andre[/url]
> [url]http://spaces.msn.com/members/adacosta[/url]
> FAQ for MS AntiSpy [url]http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm[/url]
>
> "Neal Duitz" <nduitz@socal.rr.com> wrote in message
> news:138A7E2C-0D03-4BB4-9202-28A1D830B165@microsoft.com...

>> Good Day Friends,
>>
>> I received my beta kit last night (March 10th) and after a failed upgrade
>> install decided to go for broke do a clean install, which seemed to work
>> much better. At any rate, with the exception of the lack of drivers for
>> my HP Photosmart 7660 printer and my Philips Acoustic Edge Sound Card
>> (PSC 706) all is going pretty well. However, I seem to have run into a
>> permissions problem. I have installed Office 2003 and MS Money 2006 and
>> was attempted to open my existing (Pre Vista) PST and Money files but
>> each time I am denied access. The system telle me that I may not have
>> permission. I am the only administrator on my system and have not changed
>> any of the default settings. Can you advise?
>>
>> Thanks in Advance,
>>
>> Neal Duitz

>
>

[Andre Da Costa [Extended64]]

It would be best to re-enable it to see if it would work. :) Especially
since Microsoft is expecting all users to operate all the time under UAP. :)
--
Andre
Extended64 | [url]http://www.extended64.com[/url]
Blog | [url]http://www.extended64.com/blogs/andre[/url]
[url]http://spaces.msn.com/members/adacosta[/url]
FAQ for MS AntiSpy [url]http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm[/url]

"Neal Duitz" <nduitz@socal.rr.com> wrote in message
news:8AE8FA13-00DF-4E13-934D-E161622FECC7@microsoft.com...

> Thanks Andre,
>
> That seemed to do the trick. I followed your instructinons and solved the
> problems with the two files. One quick follow up. Should I now re enable
> UAP or will that cause the problem to reappear?
>
> Thanks Again,
>
> Neal
> "Andre Da Costa [Extended64]" <andred25@hotmail.com> wrote in message
> news:uKtOYlXRGHA.1688@TK2MSFTNGP11.phx.gbl...

>> Try disabling UAP and see if it fixes the issue, Click Start > All
>> Programs

>> > Accessories > Run > type MSCONFIG > Tools (tab) scroll down > select

>> Disable UAP > click Launch > OK. Restart the system and try importing the
>> .pst
>> --
>> Andre
>> Extended64 | [url]http://www.extended64.com[/url]
>> Blog | [url]http://www.extended64.com/blogs/andre[/url]
>> [url]http://spaces.msn.com/members/adacosta[/url]
>> FAQ for MS AntiSpy [url]http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm[/url]
>>
>> "Neal Duitz" <nduitz@socal.rr.com> wrote in message
>> news:138A7E2C-0D03-4BB4-9202-28A1D830B165@microsoft.com...

>>> Good Day Friends,
>>>
>>> I received my beta kit last night (March 10th) and after a failed
>>> upgrade install decided to go for broke do a clean install, which seemed
>>> to work much better. At any rate, with the exception of the lack of
>>> drivers for my HP Photosmart 7660 printer and my Philips Acoustic Edge
>>> Sound Card (PSC 706) all is going pretty well. However, I seem to have
>>> run into a permissions problem. I have installed Office 2003 and MS
>>> Money 2006 and was attempted to open my existing (Pre Vista) PST and
>>> Money files but each time I am denied access. The system telle me that I
>>> may not have permission. I am the only administrator on my system and
>>> have not changed any of the default settings. Can you advise?
>>>
>>> Thanks in Advance,
>>>
>>> Neal Duitz

>>
>>

>

[Andre Da Costa [Extended64]]

Could you try giving help instead of plugging your Vista base? No problem
with plugging your website though, but offering the tip, plus the link
usually generates more hits. ;-)
--
Andre
Extended64 | [url]http://www.extended64.com[/url]
Blog | [url]http://www.extended64.com/blogs/andre[/url]
[url]http://spaces.msn.com/members/adacosta[/url]
FAQ for MS AntiSpy [url]http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm[/url]

"Zack Whittaker (R2 Mentor)" <admin@zacknet.co.uk> wrote in message
news:%23b34tjXRGHA.4452@TK2MSFTNGP12.phx.gbl...

>I can test my new PHP system right now :op I think you need to disable UAP
>on your computer. Go here:
>[url]http://www.zacknet.co.uk/vistabase/pages.php?subcats/security/whatisuap[/url]
>
> (Now I hope that PHP thing works now... because I spent 3 days trying to
> work out how to direct link to my articles!)
>
> --
> Zack Whittaker
> Microsoft Beta (Windows Server R2 Beta Mentor)
> » ZackNET Enterprises: [url]www.zacknet.co.uk[/url]
> » MSBlog on ResDev: [url]http://msblog.resdev.net[/url]
> » ZackNET Forum: [url]www.zacknet.co.uk/forum[/url]
> » VistaBase: [url]www.zacknet.co.uk/vistabase[/url]
> » This mailing is provided "as is" with no warranties, and confers no
> rights. All opinions expressed are those of myself unless stated so, and
> not
> of my employer, best friend, mother or cat. Let's be clear on that one!
>
>
> --- Original message follows ---
> "Neal Duitz" <nduitz@socal.rr.com> wrote in message
> news:138A7E2C-0D03-4BB4-9202-28A1D830B165@microsoft.com...

>> Good Day Friends,
>>
>> I received my beta kit last night (March 10th) and after a failed upgrade
>> install decided to go for broke do a clean install, which seemed to work
>> much better. At any rate, with the exception of the lack of drivers for
>> my HP Photosmart 7660 printer and my Philips Acoustic Edge Sound Card
>> (PSC 706) all is going pretty well. However, I seem to have run into a
>> permissions problem. I have installed Office 2003 and MS Money 2006 and
>> was attempted to open my existing (Pre Vista) PST and Money files but
>> each time I am denied access. The system telle me that I may not have
>> permission. I am the only administrator on my system and have not changed
>> any of the default settings. Can you advise?
>>
>> Thanks in Advance,
>>
>> Neal Duitz

>
>

[Zack Whittaker \(R2 Mentor\)]

Well, the thing is is that instead of simply copying and pasting the content
from my site, it's easier to give the link. Why else did you think I made
VistaBase for? For newsgrouping, that's it :o)

--
Zack Whittaker
Microsoft Beta (Windows Server R2 Beta Mentor)
» ZackNET Enterprises: [url]www.zacknet.co.uk[/url]
» MSBlog on ResDev: [url]http://msblog.resdev.net[/url]
» ZackNET Forum: [url]www.zacknet.co.uk/forum[/url]
» VistaBase: [url]www.zacknet.co.uk/vistabase[/url]
» This mailing is provided "as is" with no warranties, and confers no
rights. All opinions expressed are those of myself unless stated so, and not
of my employer, best friend, mother or cat. Let's be clear on that one!


--- Original message follows ---
"Andre Da Costa [Extended64]" <andred25@hotmail.com> wrote in message
news:eamHAqYRGHA.4740@TK2MSFTNGP14.phx.gbl...

> Could you try giving help instead of plugging your Vista base? No problem
> with plugging your website though, but offering the tip, plus the link
> usually generates more hits. ;-)
> --
> Andre
> Extended64 | [url]http://www.extended64.com[/url]
> Blog | [url]http://www.extended64.com/blogs/andre[/url]
> [url]http://spaces.msn.com/members/adacosta[/url]
> FAQ for MS AntiSpy [url]http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm[/url]
>
> "Zack Whittaker (R2 Mentor)" <admin@zacknet.co.uk> wrote in message
> news:%23b34tjXRGHA.4452@TK2MSFTNGP12.phx.gbl...

>>I can test my new PHP system right now :op I think you need to disable UAP
>>on your computer. Go here:
>>[url]http://www.zacknet.co.uk/vistabase/pages.php?subcats/security/whatisuap[/url]
>>
>> (Now I hope that PHP thing works now... because I spent 3 days trying to
>> work out how to direct link to my articles!)
>>
>> --
>> Zack Whittaker
>> Microsoft Beta (Windows Server R2 Beta Mentor)
>> » ZackNET Enterprises: [url]www.zacknet.co.uk[/url]
>> » MSBlog on ResDev: [url]http://msblog.resdev.net[/url]
>> » ZackNET Forum: [url]www.zacknet.co.uk/forum[/url]
>> » VistaBase: [url]www.zacknet.co.uk/vistabase[/url]
>> » This mailing is provided "as is" with no warranties, and confers no
>> rights. All opinions expressed are those of myself unless stated so, and
>> not
>> of my employer, best friend, mother or cat. Let's be clear on that one!
>>
>>
>> --- Original message follows ---
>> "Neal Duitz" <nduitz@socal.rr.com> wrote in message
>> news:138A7E2C-0D03-4BB4-9202-28A1D830B165@microsoft.com...

>>> Good Day Friends,
>>>
>>> I received my beta kit last night (March 10th) and after a failed
>>> upgrade install decided to go for broke do a clean install, which seemed
>>> to work much better. At any rate, with the exception of the lack of
>>> drivers for my HP Photosmart 7660 printer and my Philips Acoustic Edge
>>> Sound Card (PSC 706) all is going pretty well. However, I seem to have
>>> run into a permissions problem. I have installed Office 2003 and MS
>>> Money 2006 and was attempted to open my existing (Pre Vista) PST and
>>> Money files but each time I am denied access. The system telle me that I
>>> may not have permission. I am the only administrator on my system and
>>> have not changed any of the default settings. Can you advise?
>>>
>>> Thanks in Advance,
>>>
>>> Neal Duitz

>>
>>

>
>

[Zack Whittaker \(R2 Mentor\)]

Yeh, the more feedback you can give about UAP, the better MSFT will end up
making it... because at the moment, I don't know of a single person who
keeps it on all the time ;o) Hehe.

--
Zack Whittaker
Microsoft Beta (Windows Server R2 Beta Mentor)
» ZackNET Enterprises: [url]www.zacknet.co.uk[/url]
» MSBlog on ResDev: [url]http://msblog.resdev.net[/url]
» ZackNET Forum: [url]www.zacknet.co.uk/forum[/url]
» VistaBase: [url]www.zacknet.co.uk/vistabase[/url]
» This mailing is provided "as is" with no warranties, and confers no
rights. All opinions expressed are those of myself unless stated so, and not
of my employer, best friend, mother or cat. Let's be clear on that one!


--- Original message follows ---
"Andre Da Costa [Extended64]" <andred25@hotmail.com> wrote in message
news:%23$B3SoYRGHA.1728@TK2MSFTNGP11.phx.gbl...

> It would be best to re-enable it to see if it would work. :) Especially
> since Microsoft is expecting all users to operate all the time under UAP.
> :)
> --
> Andre
> Extended64 | [url]http://www.extended64.com[/url]
> Blog | [url]http://www.extended64.com/blogs/andre[/url]
> [url]http://spaces.msn.com/members/adacosta[/url]
> FAQ for MS AntiSpy [url]http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm[/url]
>
> "Neal Duitz" <nduitz@socal.rr.com> wrote in message
> news:8AE8FA13-00DF-4E13-934D-E161622FECC7@microsoft.com...

>> Thanks Andre,
>>
>> That seemed to do the trick. I followed your instructinons and solved the
>> problems with the two files. One quick follow up. Should I now re enable
>> UAP or will that cause the problem to reappear?
>>
>> Thanks Again,
>>
>> Neal
>> "Andre Da Costa [Extended64]" <andred25@hotmail.com> wrote in message
>> news:uKtOYlXRGHA.1688@TK2MSFTNGP11.phx.gbl...

>>> Try disabling UAP and see if it fixes the issue, Click Start > All
>>> Programs
>>> > Accessories > Run > type MSCONFIG > Tools (tab) scroll down > select
>>> Disable UAP > click Launch > OK. Restart the system and try importing
>>> the .pst
>>> --
>>> Andre
>>> Extended64 | [url]http://www.extended64.com[/url]
>>> Blog | [url]http://www.extended64.com/blogs/andre[/url]
>>> [url]http://spaces.msn.com/members/adacosta[/url]
>>> FAQ for MS AntiSpy [url]http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm[/url]
>>>
>>> "Neal Duitz" <nduitz@socal.rr.com> wrote in message
>>> news:138A7E2C-0D03-4BB4-9202-28A1D830B165@microsoft.com...
>>>> Good Day Friends,
>>>>
>>>> I received my beta kit last night (March 10th) and after a failed
>>>> upgrade install decided to go for broke do a clean install, which
>>>> seemed to work much better. At any rate, with the exception of the lack
>>>> of drivers for my HP Photosmart 7660 printer and my Philips Acoustic
>>>> Edge Sound Card (PSC 706) all is going pretty well. However, I seem to
>>>> have run into a permissions problem. I have installed Office 2003 and
>>>> MS Money 2006 and was attempted to open my existing (Pre Vista) PST and
>>>> Money files but each time I am denied access. The system telle me that
>>>> I may not have permission. I am the only administrator on my system and
>>>> have not changed any of the default settings. Can you advise?
>>>>
>>>> Thanks in Advance,
>>>>
>>>> Neal Duitz
>>>
>>>

>>

>
>

[Tekguru (Daron Brewood)]

On Sun, 12 Mar 2006 11:39:32 -0000, Zack Whittaker (R2 Mentor) wrote:

> Yeh, the more feedback you can give about UAP, the better MSFT will end up
> making it... because at the moment, I don't know of a single person who
> keeps it on all the time ;o) Hehe.

Zack, can this affect things like program install, as a lot of progs I'm
trying to install end up creating directories and that is about all.
--
Tekguru (Daron Brewood)
MS-MVP/Mobile Devices

Webmaster: UKs largest Pocket PC Site
[url]http://www.4WinMobile.com[/url]

[Zack Whittaker \(R2 Mentor\)]

Yeh, UAP can restrict programs installing unless you are the administrator.
Also, if you have UAP enabled and you want to create a new folder in
%programfiles% for a new program group, this might be restricted also. So
yeh, UAP in general tightens things down so that the user cannot make system
wide changes which would then affect other users.

Check out this article, explains it better -
[url]http://www.zacknet.co.uk/vistabase/welcome.php?subcats/security/whatisuap[/url]

--
Zack Whittaker
Microsoft Beta (Windows Server R2 Beta Mentor)
» ZackNET Enterprises: [url]www.zacknet.co.uk[/url]
» MSBlog on ResDev: [url]http://msblog.resdev.net[/url]
» ZackNET Forum: [url]www.zacknet.co.uk/forum[/url]
» VistaBase: [url]www.zacknet.co.uk/vistabase[/url]
» This mailing is provided "as is" with no warranties, and confers no
rights. All opinions expressed are those of myself unless stated so, and not
of my employer, best friend, mother or cat. Let's be clear on that one!


--- Original message follows ---
"Tekguru (Daron Brewood)" <tekguru@tekguru.co.uk> wrote in message
news:6rhpyk09pyhe$.dlg@tekguru.co.uk...

> On Sun, 12 Mar 2006 11:39:32 -0000, Zack Whittaker (R2 Mentor) wrote:
>

>> Yeh, the more feedback you can give about UAP, the better MSFT will end
>> up
>> making it... because at the moment, I don't know of a single person who
>> keeps it on all the time ;o) Hehe.

>
> Zack, can this affect things like program install, as a lot of progs I'm
> trying to install end up creating directories and that is about all.
> --
> Tekguru (Daron Brewood)
> MS-MVP/Mobile Devices
>
> Webmaster: UKs largest Pocket PC Site
> [url]http://www.4WinMobile.com[/url]

[Tekguru (Daron Brewood)]

On Sun, 12 Mar 2006 16:36:00 -0000, Zack Whittaker (R2 Mentor) wrote:

> Yeh, UAP can restrict programs installing unless you are the administrator.
> Also, if you have UAP enabled and you want to create a new folder in
> %programfiles% for a new program group, this might be restricted also. So
> yeh, UAP in general tightens things down so that the user cannot make system
> wide changes which would then affect other users.

Cheers Zack, will read up later. Did not change the problem I had which was
getting Directory Opus 8 to install though. In the end I ran the installer
and copied the files over from the MCE2005 part of the system and that at
least had got around it. So to me it looks like installers need to be
updated to ensure they are fully Vista aware.
--
Tekguru (Daron Brewood)
MS-MVP/Mobile Devices

Webmaster: UKs largest Pocket PC Site
[url]http://www.4WinMobile.com[/url]