PLEASE HELP. Access to db locked.

[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 have already given the IUSR_Machine account modify
rights over the folder that holds the database.

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.

[Raymond D'Anjou \(raydan\)]

Google '0x80004005' and you may find your answer.

"Carlos Sol" <solis@rice.edu> wrote in message
news:O6I$4VjTEHA.760@TK2MSFTNGP12.phx.gbl...

> 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 have already given the IUSR_Machine account modify
> rights over the folder that holds the database.
>
> 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.
>
>
>
>

[Aaron [SQL Server MVP]]

[url]http://www.aspfaq.com/5003[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"Carlos Sol" <solis@rice.edu> wrote in message
news:O6I$4VjTEHA.760@TK2MSFTNGP12.phx.gbl...

> 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 have already given the IUSR_Machine account modify
> rights over the folder that holds the database.
>
> 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.
>
>
>
>