Could not save(modify) record

[Sajid]

Hi

I'm developing an online shopping cart. When user modifies
a record, it generates following error:

Microsoft OLE DB Provider for ODBC Drivers
error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not save;
currently locked by user 'admin' on machine 'XYZ'.

...../addProduct.asp, line 60

This error does not appear on each record but, on some of
the records. Others modify successfully. I dont know
what's happening.

Regards
Sajid

[Aaron Bertrand - MVP]

Where is the CODE that modified the record? Are you using an
ADODB.Recordset object, and rs.update methodology? Or are you using a
direct UPDATE statement, or a stored query?

Who is the admin user on machine XYZ? Is it possible someone has the MDB
file open on their machine?

Are you closing/destroying your recordset/connection objects on every page?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Sajid" <sajid622@hotmail.com> wrote in message
news:04ae01c3c2fa$74874320$a501280a@phx.gbl...

> Hi
>
> I'm developing an online shopping cart. When user modifies
> a record, it generates following error:
>
> Microsoft OLE DB Provider for ODBC Drivers
> error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Could not save;
> currently locked by user 'admin' on machine 'XYZ'.
>
> ..../addProduct.asp, line 60
>
> This error does not appear on each record but, on some of
> the records. Others modify successfully. I dont know
> what's happening.
>
> Regards
> Sajid
>
>

[Jeff Cochran]

On Mon, 15 Dec 2003 02:59:04 -0800, "Sajid" <sajid622@hotmail.com>
wrote:

>Hi
>
>I'm developing an online shopping cart. When user modifies
>a record, it generates following error:
>
>Microsoft OLE DB Provider for ODBC Drivers
>error '80004005'
>
>[Microsoft][ODBC Microsoft Access Driver] Could not save;
>currently locked by user 'admin' on machine 'XYZ'.
>
>..../addProduct.asp, line 60
>
>This error does not appear on each record but, on some of
>the records. Others modify successfully. I dont know
>what's happening.

FAQ:

Why do I get database-related 80004005 errors?
[url]http://www.aspfaq.com/show.asp?id=2009[/url]

Jeff