Re: Access Database through ASP
- From: "Doug" <dtcress@xxxxxxxxxxxxxx>
- Date: Thu, 22 Sep 2005 22:45:26 -0500
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" <tulsaalstonsNOSPAM@xxxxxxx> wrote in message
news:3LnYe.81513$DW1.40779@xxxxxxxxxxxxx
> 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/Documents/Microsoft%20Access%20Developer%20Transition%20to%20Internet.htm
>
>
http://members.cox.net/tulsaalstons/Documents/Access-WebConversionSoftware.htm
>
> Bob
.
- Prev by Date: Dynamic Crosstab Report Problem
- Next by Date: The EXISTS operator in A97 SQL - I cannot find documentation on it in A97 HELP
- Previous by thread: Dynamic Crosstab Report Problem
- Next by thread: The EXISTS operator in A97 SQL - I cannot find documentation on it in A97 HELP
- Index(es):
Relevant Pages
|
