Connect to Access without IUSR

[svennkjetil]

Hi.

I have a server A with some ASP-pages which shall access a MS Access database on another server B (company nettwork drive). In order to connect I normally would give the directory with the Access database the IUSR permissions.

But it is difficult for me to get the system administrators in the company to allow IUSR permissions. Instead I would like to connect to Access using my nettwork user (NA1234).

I tried the following:
oCon.Open "DRIVER={Microsoft Access Driver (*.mdb)};pwd=abcd;Uid=NA1234;DBQ=o:\db1.mdb"
- I got the usual message: "...It is already opened exclusively by another user, or you need permission to view its data."

The ASP-pages on server A shall be accessed from other collegues within the company nettwork.

Any suggestions?

Svenn Kjetil

 

[shaddow]

U have to set the at security tab of this file to be accesed by everyone "read only or full" or by an user ________
George, M

 

[svennkjetil]

Since the Access database is on another server I can't change the permissions, but I can see that it is set up with all rights for everybody. However I need to access the disk with my logon user 'NA1234' and not IUSER...

 

[shaddow]

Ask the admin to see if u have the right permission on your network acoount... cuz your account is not "everyone" account and it could be some restrictions to your account ________
George, M

 

[svennkjetil]

I can access the database, open it, change it and delete it. From a VBSript in Outlook I also open the database and write data into it. So how can I be missing permissions as my user NA1234?

I rather think that the problem is that I try to connect from the ASP-page with IUSR, but I don't know how to connect using NA1234. Is my connection string correct?

 

[shaddow]

I really dont know a method to not use IUSR but,
try to use a DSN to that file (and then u could look at this DSN file to see whitch fields in your connection is missing), this should work

this is my dsn example file

[ODBC]
DRIVER=Microsoft dBase Driver (*.dbf)
UID=admin
UserCommitSync=Yes
Threads=3
Statistics=0
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=dBase 5.0
DriverId=533
Deleted=0
DefaultDir=E:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\Project1
CollatingSequence=ASCII

________
George, M

 

[JGillespie]

Think the problem is that IUSR account does not count as an interactively logged on account like your normal network account. See Microsoft Knowledge Base for loading a different user hive into the registry which should allow you to do what you want.

Would be far simpler for you to change the user account that IIS uses for your ASP pages to your network user account rahter than the default IUSR account. Jamie Gillespie
j-gillespie@s-cheshire.ac.uk

 

[svennkjetil]

Didn't understand the first part about loading a different user, but the second part is actually what I am trying to do!

Tried to set my network user in IIS in many ways, inluding domane name: "lgnr\NA1234". Do you know how I shall configure this? Should I for example use anonymous or authenticated access?

And would a person with login NA3456 be able to access my ASP-pages?

Svenn Kjetil