Just as ASP pages script to edit the DB
See
http://www.asp101.com/samples/db_edit.asp
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| Thank you so much for your help. I just talked with one of the actual users
| of the database. She described the problem just as you had said. No one
| could access the page when they were in the database. I will work on your
| suggestions.
|
| Thank you again.
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > Well, that is what's locking it and causing problems for the users of the
| > asp query page. You either need to export a copy of it to a file based
| > location outside of the web, or create some asp pages that will let them
| > edit the database in the web. You might try the FrontPage Database Interface
| > Wizard as a quick way to get some pages up and running for them.
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web:
http://www.spiderwebwoman.com/resources/
| > Please reply to the newsgroup for the benefit of others.
| >
| >
| >
| >
| > | > > Yes. Unfortunately, because the page wasn't working to give them access
| > > to
| > > the database, they have had to go directly to Access Database file via
| > > Windows Explorer to make updates.
| > >
| > > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >
| > >> Are they opening the web-based database using Access?
| > >>
| > >> --
| > >>
| > >> ~ Kathleen Anderson
| > >> Microsoft MVP - FrontPage
| > >> Spider Web Woman Designs
| > >> web:
http://www.spiderwebwoman.com/resources/
| > >> Please reply to the newsgroup for the benefit of others.
| > >>
| > >>
| > >>
| > >>
| > >> | > >> > Actually, what happens is we have a button on the page that opens a
| > >> > separate
| > >> > window and actually opens the database. The default mode for the
| > >> > database
| > >> > is
| > >> > "Shared", so several people should be able to open it at once. Are you
| > >> > saying that if someone opens the database, the asp page won't be able
| > >> > to
| > >> > access it?
| > >> >
| > >> >
| > >> >
| > >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >
| > >> >> I wouldn't think that an asp page used to edit a record in a database
| > >> >> would
| > >> >> lock the database. Do you have access to the source code of the page
| > >> >> that's
| > >> >> being used to edit the record? Can you post it here?
| > >> >>
| > >> >> --
| > >> >>
| > >> >> ~ Kathleen Anderson
| > >> >> Microsoft MVP - FrontPage
| > >> >> Spider Web Woman Designs
| > >> >> web:
http://www.spiderwebwoman.com/resources/
| > >> >> Please reply to the newsgroup for the benefit of others.
| > >> >>
| > >> >>
| > >> >>
| > >> >>
| > >> >> | > >> >> > The database is located on the server with the web files. This
| > >> >> > worked
| > >> >> > on
| > >> >> > a
| > >> >> > different network, but when they moved to this one we started having
| > >> >> > all
| > >> >> > these problems. The page provided an option to actually edit the
| > >> >> > database
| > >> >> > and we had no problems before. When the database is accessed via
| > >> >> > the
| > >> >> > asp
| > >> >> > code, is it supposed to "lock" the database? It seems to me it was
| > >> >> > supposed
| > >> >> > to open the page, present the report (sorted however the user
| > >> >> > wants),
| > >> >> > then
| > >> >> > release the database for the next person. Does this sound right?
| > >> >> >
| > >> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >> >
| > >> >> >> If you've got people opening the web-based database in Access they
| > >> >> >> are
| > >> >> >> locking it which is why the asp page is having a problem. If they
| > >> >> >> need
| > >> >> >> the
| > >> >> >> data, I would recommend you export the database from the web to a
| > >> >> >> disk-based
| > >> >> >> location where they can work with it offline.
| > >> >> >>
| > >> >> >> --
| > >> >> >>
| > >> >> >> ~ Kathleen Anderson
| > >> >> >> Microsoft MVP - FrontPage
| > >> >> >> Spider Web Woman Designs
| > >> >> >> web:
http://www.spiderwebwoman.com/resources/
| > >> >> >> Please reply to the newsgroup for the benefit of others.
| > >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >> >> | > >> >> >> >I have a database (Access 2000). I access it via a webpage (asp)
| > >> >> >> >to
| > >> >> >> >present
| > >> >> >> > a report page. Multiple people can open the database directly,
| > >> >> >> > but
| > >> >> >> > when
| > >> >> >> > trying to run the asp file via the web, only one user can get the
| > >> >> >> > correct
| > >> >> >> > page. Everyone else receives:
| > >> >> >> >
| > >> >> >> > A problem was encountered while connecting to name.mdb
| > >> >> >> > Error source: MicroSoft JET Database Engine
| > >> >> >> > Error description: Could not use";file already in use
| > >> >> >> > Error Number: -2147467259
| > >> >> >> >
| > >> >> >> > I cannot tell if it is how I am trying to connect to the database
| > >> >> >> > or
| > >> >> >> > how
| > >> >> >> > the
| > >> >> >> > database is structured. I inherited this project from someone I
| > >> >> >> > can
| > >> >> >> > no
| > >> >> >> > longer contact.
| > >> >> >> >
| > >> >> >> > Any help would be greatly appreciated.
| > >> >> >> >
| > >> >> >> > Thank you
| > >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >