Check for the permissions that exist in windows itself. The error you are
getting could have nothing to do with the passwords that are within access,
but for the windows account that the OS uses to access the db. By default,
the IUSR_machinename account (internet user anonymous account, format is
IUSR_ followed by the name of the computer) does not have write access to
files. When you imported the database FP imported it as a normal file
probably. This means it doesn't have the permissons on it. One of the
reasons that FP creates directories such as _private abd _fpdb is to have a
place that has write permissions. You can either set the file permissions
for this file manually through Windows Explorer, add the IUSR account if not
present, and give the IUSR account Write permissions, or try placing it
within the _private directory or another write-enabled directory.
Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage
"jimt" <(E-Mail Removed)> wrote in message
news:A7BAC93B-9B30-4B8C-A934-(E-Mail Removed)...
>I apologize to start for the forecoming long explanation of the problem. I
> have an Access 2000 database that contains data about the properties in
> town.
> I'm new at FP2000, ASP, etc; but have experience with VBA. In starting the
> development effort I created a copy (subset) of the town database and
> imported it into FP. I've have created a number of ASP pages that access
> the
> subset database OK; however I have the DB connection code in each of the
> pages. I have started to pull the code out of the ASP pages and making the
> connection via an include file (right thing to do especially since my
> future
> Host will have the DB in a different directory name than FP recommended
> directory). I've tested the code in one of the pages and everything seems
> to
> work OK. So the next thing I did was to import the full town database into
> FP
> using the import option after opening the web with the "open web" method.
> The
> import was OK and I then used the tools/web option/database menu to verify
> the larger DB (kept the subset there also). The full DB shows as verified.
>
> If I change the include file to the full DB name and run the one ASP page
> I'm testing; I get an error when it hits (1st sql) the "Set
> rssk=conntemp.execute(SQLsk)" line in the test ASP page that queries a
> file
> in the DB named "system_control". The error message reads:
>
> Microsoft JET Database Engine (0x80040E09)
> Record(s) cannot be read; no read permission on 'system_control'.
> /ASP/land.asp, line 48
>
> Both DB are password protected, both DB have the rights to the table set
> for
> all rights. The subset DB works in both "hard coded" and include file
> senerios. The full DB does not work in either case.
>
> It appears I must have missed a step in setting up the full DB. Is there
> something in IIS I need to do or ???
>
> Thanks
> Jim T.
>
>
|
Similar Threads
