Data Access Vista/IIS&/Access2000

H

hugh welford

Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting server error.

I think the problem is in the file permission. Under XP Pro/IIS6 is used to
have to set the .mdb file security via windows explorer to give
IUSR_machinename full permissions on this file for anonymous web access.

Cant seem to do this with Vista explorer - says object cannot be found.

Also, getting conflicting statements from IIS Help - it tells me firstly
that

a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
This account is created when you install IIS 7.0.

and then

b. Similarly, a new Windows built-in account named IUSRS replaces the
local IUSR_MachineName anonymous account from IIS 6.0.

Anyway, whatever syntax I use, I cant seem to add anonymous web user
permission to daters.mdb via the security tab in Windown Explorer.

Any help greatly appreciated - getting very frustrated

Thanks

Hugh
 
B

Bob Milutinovic

hugh welford said:
Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting server error.

I know this is a Microsoft group and I'll get shot down for saying this,
but...

1. Remove Vista
2. Revert to XP Pro (or preferably Server 2003)
3. Wait 18 months to 2 years for sufficient servicepacks to render Vista
usable.

Past experience has shown (think back even to MS-DOS 4) that you should
never trust a new operating system for any critical use. Might be great for
games, but wait 'til it's had at least the major failings ironed out before
using it for work.

--
Bob Milutinovic
Cognicom - "Australia's Web Presence Specialists"
http://www.cognicom.net.au/
telephone (0417) 45-77-66
facsimile (02) 9824-2240
 
B

Bob Barrows [MVP]

hugh said:
Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting server error.

Huh? What is the error message?
I think the problem is in the file permission.

Why? Does the error message give you a clue?
If it IS a file permission error, you need to figure out how to assign
Modify permissions for the folder containing the file to ALL users of the
database file. Try posting to a Vista group for help with that, or maybe
someone in the iis group will be able to help.
 
H

hugh welford

Hi Bob

Thanks for reply.

The error merssage is the non-specific "An error occurred on the server when
processing the URL" - not much help is it?

I am assuming that the error is a permissions problem, as I have not been
able to set the full permissions for the file - hence the post. I will
re-post in vista and iis groups as suggested - thanks.

Hugh
 
B

Bob Barrows [MVP]

Well your first step should be to shut off "friendly errors".
This can be done in IIS Manager and may also need to be done in the
browser you are using.
 
H

hugh welford

Thanks Bob.

Made a few changes, and now getting unspecified error on trying to open a
connection with the string

cst = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
Source=c:/access/brits/daters.mdb"

Presume new Provider with Vista.

Any idea what the correct string should be under Vista???

Thanks

Hugh
 
H

hugh welford

Thanks again, Bob.

It was permissions after all - it appears the following must have full
control permissions for IUSR and IIS_IUSRS accounts

a. The .mdb file to be accessed
b. C:\Windows\Temp
c. C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp

Hope this is useful

Regards

Hugh
 
B

Bob Barrows [MVP]

"Full" permissions is overkill. All that is required is "Modify". The
users do not need the ability to assign permissions. Always work from
the standpoint of assigning the least level of permission required to
perform the task. In this case, users need to be able to create, modify
and delete a locking file to enable multi-user access to the mdb file.
The only permission required for that is "Modify", known as "Read/Write"
in some OSs.
 
A

Adrienne Boswell

The error merssage is the non-specific "An error occurred on the
server when processing the URL" - not much help is it?

Do you have friendly errors messages turned on? IIRC, that's what the
"friendly" error message is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,904
Latest member
HealthyVisionsCBDPrice

Latest Threads

Top