HI

I am trying to acheive just a simple update on a database but it just isnt happening. very time i go to update i get the error:


Microsoft JET Database Engine error '80004005'

The search key was not found in any record.

/shop/admin_updatedesc_new.asp, line 113


This normally means that the database has become corrupt some way. Well i have repaired the database, i have created a new database but i still get the same error.

What is going wrong.

ny help reatly appreciated.

Regards


Simon

DWMX 2004 | ASP | VBScript

mm never heard of this one .. does this table have a primary key does it have identity ?

it has a primary key assigned but what do you mean by identity?

Simon

DWMX 2004 | ASP | VBScript

Found this:

The search key was not found in any record.
Microsoft JET Database Engine (0x80004005)
The search key was not found in any record.
This error often means that the database has become corrupted.

To coerrect the error the database needs to be repaired. If the database is on a remote server download the database and foillow the instructions below to repair the database.

Open the database in Microsoft Access, click on the 'Tools' menu and select 'Database Utilities -> Compact and Repair Database'.

Here:

www.webwizguide.info/asp/faq/access_database_faq.asp

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

thanks lee,

I have tried this and even created a new database but keep getting the same error the first time i do an update on the database.

Do you think it could be an issue with the host?

Simon

DWMX 2004 | ASP | VBScript

Hi Simon

Absolutely no idea.

You could try creating a new test db and upload that one so you have a new db on the server, not just overwriting the old one and see what results you get back.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

hi lee,

tried that - but to no avail. Created a completely seperate database and uploaded it. It can be queried fine and will display any data called - but as soon as you do an update on the database it gives sthat same error.

Its driving me crazy!!!!

Simon

DWMX 2004 | ASP | VBScript

If it's working fine locally, then give them a call. I don't know what else to suggest Simon.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

Am in contact with my host at the minute - many thanks for taking at look at this lee.

regards

Simon

DWMX 2004 | ASP | VBScript