You should not have opened the Access DB from w/i FP
(always export the db to your PC and open from there)
Try Tools Site Settings Database and if you see it listed select the option to remove it
- you may need to have you host stop & restart the server to clear your DB locked error
|I had no idea how hard it was to figure this stuff out!
| No, the only thing that shows is the Parents.mdb
| I opened the database from within Frontpage, and when I tried to close I got
| the message: Server error: Cannot lock file "Parents.mdb". eith the file is
| no use or the web server is temporarily busy.
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > Now you know what I meant when I said: "The questions about why something
| > isn't working are much more difficult to answer.".
| >
| > I've always been under the impression, and I could be wrong, that you
| > can/should only have two databases in a root web or subweb.
| >
| > By any chance do you see a file in the fpdb folder called parents.ldb?
| >
| > --
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web:
http://www.spiderwebwoman.com/resources/
| >
| >
| > | > >I was able to export to my desktop and the files look good, so I am
| > > proceeding. Theyre are acturally 5 little databases in the fpdb folder,
| > > all
| > > with differernt connections. I started to delete them, but one will not
| > > delete I get the message: Server error: Cannot remove file:
| > > "Parents.mdb".
| > > I tried deleting the folder fpdb and it won't delete either, giving me the
| > > same message:
| > > Server error: Cannot remove file: "Parents.mdb".
| > > Should I proceed?
| > >
| > >
| > > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >
| > >> It's possible that moving the files out of the _fpclass folder, instead
| > >> of
| > >> just overlaying them, might have something to do with this.
| > >>
| > >> This is still just a test web site, yes? If you can, try this: open the
| > >> web,
| > >> export the database to your desktop, delete the database from the web,
| > >> delete the fpdb folder, delete the global.asa, and delete the _fpclass
| > >> folder.
| > >>
| > >> Close the web, open it again, and import the database from your desktop
| > >> back
| > >> into your web. This will recreate the fpdb and _fpclass folders, and the
| > >> global.asa.
| > >>
| > >> At this point, try creating a simple query page using the Database
| > >> Results
| > >> Wizard and see if it works.
| > >>
| > >> --
| > >> ~ Kathleen Anderson
| > >> Microsoft MVP - FrontPage
| > >> Spider Web Woman Designs
| > >> web:
http://www.spiderwebwoman.com/resources/
| > >>
| > >>
| > >> | > >> > Same error
| > >> > see page
| > >> >
http://www.diocesephoenix.org/school/seton_catholic_hs/Alumni/resultsYear.asp
| > >> >
| > >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >
| > >> >> Try turning off Show Friendly HTTP Error Messages in IE:
| > >> >>
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q294807 to see
| > >> >> if
| > >> >> you can get more information about the error.
| > >> >>
| > >> >> --
| > >> >> ~ Kathleen Anderson
| > >> >> Microsoft MVP - FrontPage
| > >> >> Spider Web Woman Designs
| > >> >> web:
http://www.spiderwebwoman.com/resources/
| > >> >>
| > >> >>
| > >> >> | > >> >> > Thank you for the resource at
www.frontpagewebmaster.com. After
| > >> >> > reading
| > >> >> > lots
| > >> >> > of threads, I replaced the files, first moving the old ones to a
| > >> >> > different
| > >> >> > folder _fpclassold. But the hyperlinks "followed" the files to
| > >> >> > _fpclassold/fpdblib.inc (etc). so then I renamed the original files
| > >> >> > to
| > >> >> > fbdblibold.inc and put them back in the _fpclass directory. The
| > >> >> > hyperlinks
| > >> >> > view shows that they are directed to the correct place.
| > >> >> > Once I did this, I started getting the http error 500-12 on every
| > >> >> > .asp
| > >> >> > page.
| > >> >> > So I don't know if it worked. BeTheBall (from
| > >> >> > frontpagewebmaster.com)
| > >> >> > thinks it may be anti-virus software on the server end. I am over
| > >> >> > my
| > >> >> > head
| > >> >> > and just learning to swim with all of this.
| > >> >> > Can't figure a way to stop the application from restarting without
| > >> >> > calling
| > >> >> > the help desk in the morning. Any ideas?
| > >> >> >
| > >> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >> >
| > >> >> >> Try replacing your .inc files in the _fpclass folder with the ones
| > >> >> >> from
| > >> >> >> FP2000 - you can get them here:
| > >> >> >>
http://www.frontpagewebmaster.com/m-175524/tm.htm
| > >> >> >>
| > >> >> >> --
| > >> >> >> ~ Kathleen Anderson
| > >> >> >> Microsoft MVP - FrontPage
| > >> >> >> Spider Web Woman Designs
| > >> >> >> web:
http://www.spiderwebwoman.com/resources/
| > >> >> >>
| > >> >> >>
| > >> >> >> | > >> >> >> > About says FrontPage 2002 (10.6308.6735)SP3
| > >> >> >> >
| > >> >> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >> >> >
| > >> >> >> >> To find out if you've applied any Service Packs to FrontPage,
| > >> >> >> >> Open
| > >> >> >> >> FrontPage
| > >> >> >> >> and do a Help | About.
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >> --
| > >> >> >> >> ~ Kathleen Anderson
| > >> >> >> >> Microsoft MVP - FrontPage
| > >> >> >> >> Spider Web Woman Designs
| > >> >> >> >> web:
http://www.spiderwebwoman.com/resources/
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >> | > >> >> >> >> > There are 5 updates shown to be installed on 9/3/05. They
| > >> >> >> >> > were
| > >> >> >> >> > part
| > >> >> >> >> > of
| > >> >> >> >> > the
| > >> >> >> >> > automatic updates from Microsoft. It says they can't be
| > >> >> >> >> > removed.
| > >> >> >> >> > One
| > >> >> >> >> > of
| > >> >> >> >> > the
| > >> >> >> >> > support numbers is DA256408-A2E7-41A58AD6-62ACB86A0FD7.
| > >> >> >> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >> >> >> >
| > >> >> >> >> >> Have you applied any Service Packs to FrontPage 2002?
| > >> >> >> >> >>
| > >> >> >> >> >> --
| > >> >> >> >> >> ~ Kathleen Anderson
| > >> >> >> >> >> Microsoft MVP - FrontPage
| > >> >> >> >> >> Spider Web Woman Designs
| > >> >> >> >> >> web:
http://www.spiderwebwoman.com/resources/
| > >> >> >> >> >>
| > >> >> >> >> >>
| > >> >> >> >> >> message
| > >> >> >> >> >> | > >> >> >> >> >> >I am using: FP2002, with Office 2000 with SP1, 2 and 3.
| > >> >> >> >> >> >Windows
| > >> >> >> >> >> >XP.
| > >> >> >> >> >> > I connect remotely to the webserver, and all I know is that
| > >> >> >> >> >> > it
| > >> >> >> >> >> > does
| > >> >> >> >> >> > use
| > >> >> >> >> >> > IIS.
| > >> >> >> >> >> > Is there any way I can find out more about them (if I need
| > >> >> >> >> >> > to)
| > >> >> >> >> >> > from
| > >> >> >> >> >> > my
| > >> >> >> >> >> > end?
| > >> >> >> >> >> > "ConnerS" wrote:
| > >> >> >> >> >> >
| > >> >> >> >> >> >> When I use New > Page or Web> Database Interface Wizard>
| > >> >> >> >> >> >> Add to existing Web
| > >> >> >> >> >> >> Using an existing database connection
| > >> >> >> >> >> >> Select a table, Choice of ~TMPCLP51541, or Alumni
| > >> >> >> >> >> >> I Choose Alumni, next
| > >> >> >> >> >> >> no changes to column types
| > >> >> >> >> >> >> Check Results, Submission, and Database Editor
| > >> >> >> >> >> >>
| > >> >> >> >> >> >> and when I try to use the editor I get this error:
| > >> >> >> >> >> >> Database Results Error
| > >> >> >> >> >> >> Your page contains a query with user input parameters that
| > >> >> >> >> >> >> could
| > >> >> >> >> >> >> not
| > >> >> >> >> >> >> be
| > >> >> >> >> >> >> resolved.
| > >> >> >> >> >> >> This could happen if your DatabaseRegionStart webbot has
| > >> >> >> >> >> >> an
| > >> >> >> >> >> >> empty
| > >> >> >> >> >> >> or
| > >> >> >> >> >> >> missing
| > >> >> >> >> >> >> s-columnnames or s-columntypes attributes.
| > >> >> >> >> >> >> You may need to read Microsoft Knowledge Base Article
| > >> >> >> >> >> >> 817029.
| > >> >> >> >> >> >>
| > >> >> >> >> >> >> I can't use Workaround 1, but I can use Workaround 2 and
| > >> >> >> >> >> >> it
| > >> >> >> >> >> >> still
| > >> >> >> >> >> >> doesn't
| > >> >> >> >> >> >> work.
| > >> >> >> >> >> >> I have searched on different words in the error message
| > >> >> >> >> >> >> s-columnnames
| > >> >> >> >> >> >> and
| > >> >> >> >> >> >> s-columtypes and the only thing the knowledge base comes
| > >> >> >> >> >> >> up
| > >> >> >> >> >> >> with
| > >> >> >> >> >> >> is
| > >> >> >> >> >> >> 817029.
| > >> >> >> >> >> >> What is my next step?
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >>
| > >> >> >> >> >>
| > >> >> >> >> >>
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >