Access Database through ASP

[Doug]

I have a split, secured access DB on a webserver along with the .mdw file.
I have setup a DSN on IIS to point to the database and the mdw file. I am
able to access the DB through ASP, however I can only do this when I set the
database user permissions to allow the user to "Open Exclusive". Any other
settings than this and I get a permissions error when trying to retrieve
data through my ASP pages. I am only reading data from the DB to display on
webpages and I do not need to open the DB exclusively. I cannot understand
why this is happening. Does anyone have any suggestions on how to fix this?

Thanks,

Doug

[Bob Alston]

Doug wrote:

I have a split, secured access DB on a webserver along with the .mdw file.
I have setup a DSN on IIS to point to the database and the mdw file. I am
able to access the DB through ASP, however I can only do this when I set the
database user permissions to allow the user to "Open Exclusive". Any other
settings than this and I get a permissions error when trying to retrieve
data through my ASP pages. I am only reading data from the DB to display on
webpages and I do not need to open the DB exclusively. I cannot understand
why this is happening. Does anyone have any suggestions on how to fix this?

Thanks,

Doug

You can take a look at some of the info I learned in using Access
databases as the data source for web pages, via ASP. I found not using
DSN, but rather dynamically linking to the database to work well.

http://members.cox.net/tulsaalstons/...20Internet.htm

http://members.cox.net/tulsaalstons/...onSoftware.htm

Bob

[Doug]

Unfortunately I don't think that is an option for me. My DB resides on a
file server separate from the webserver. There is a lot of good information
on your webpage, but I did not find anything that helped my problem.

Thanks!

Doug

"Bob Alston" <tu****************@cox.net> wrote in message
news:3LnYe.81513$DW1.40779@fed1read06...

Doug wrote:

I have a split, secured access DB on a webserver along with the .mdw file. I have setup a DSN on IIS to point to the database and the mdw file. I am able to access the DB through ASP, however I can only do this when I set the database user permissions to allow the user to "Open Exclusive". Any other settings than this and I get a permissions error when trying to retrieve
data through my ASP pages. I am only reading data from the DB to display on webpages and I do not need to open the DB exclusively. I cannot understand why this is happening. Does anyone have any suggestions on how to fix this?
Thanks,

Doug

You can take a look at some of the info I learned in using Access
databases as the data source for web pages, via ASP. I found not using
DSN, but rather dynamically linking to the database to work well.

http://members.cox.net/tulsaalstons/...20Internet.htm
http://members.cox.net/tulsaalstons/...onSoftware.htm
Bob