MS Access to ASP Problem

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

Re: MS Access to ASP Problem

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

Mistake #1. See http://www.aspfaq.com/show.asp?id=2126

> 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?
>
File permissions.
One of these will contain your answer:
http://www.aspfaq.com/show.asp?id=2062
http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

Bob Barrows


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.