Multiple access to database via asp

C

Crash

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
 
K

Kathleen Anderson [MVP - FrontPage]

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.
 
C

Crash

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?
 
K

Kathleen Anderson [MVP - FrontPage]

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.
 
C

Crash

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?
 
C

Crash

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.
 
K

Kathleen Anderson [MVP - FrontPage]

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.
 
C

Crash

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.
 
S

Stefan B Rusynko

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
| > >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top