Locked data base? Please help

[Carlos Sol]

Good day

I am having a problem developing a web application for an on line catalog. I
am using ms access XP on an XP professional platfrom. I have been able to
succesfully develop a web page to query the database to produce a list of
items in groups of 10, but when I request the next 10 items the server
returns the following error:

"Error Type:
Provider (0x80004005)
Unspecified error
/ECOTAssets/AssetList.asp, line 5"

after a few seconds (about 30), if I hit reload the page will actually load.
I am assuming that the database is locked or something like that. How can I
get it to work with out these waiting periods?

Thanks very much.

[Larry Linson]

I'd bet you would have a better chance of getting a good answer if you asked
this in a newsgroup devoted to .asp. You are likely using a _Jet_ database,
but not _Access_ (Access being the user interface and application
development part of the product, Jet being the default database installed).
Even Microsoft often takes the "shortcut" of calling Jet databases "Access
databases".

On the other hand, many .asp applications use the Microsoft Data Engine
(MSDE, also known as Microsoft SQL Server Desktop Edition) which is an
alternative to Jet when using Access, but is included in the MDAC 2.x
downloads.

I presume you are using ADO (ActiveX Data Objects) or ADO.NET as your Access
method... there are newsgroups for both of those, as well. You'll find both
USENET newsgroups via your own news server, and Microsoft-sponsored
newsgroups via the free "news.microsoft.com" news server in all these
categories.

Larry Linson
Microsoft Access MVP

"Carlos Sol" <so***@rice.edu> wrote in message
news:ca**********@joe.rice.edu...

Good day

I am having a problem developing a web application for an on line catalog. I am using ms access XP on an XP professional platfrom. I have been able to
succesfully develop a web page to query the database to produce a list of
items in groups of 10, but when I request the next 10 items the server
returns the following error:

"Error Type:
Provider (0x80004005)
Unspecified error
/ECOTAssets/AssetList.asp, line 5"

after a few seconds (about 30), if I hit reload the page will actually load.

I am assuming that the database is locked or something like that. How can I get it to work with out these waiting periods?

Thanks very much.