Corrupt SQL?

[Geordiehc]

Im using SQL for Mir 3 and the magics database for some reason is not allowing any edits anymore.

We've tried importing a new database from excel but again ti will not allow edits. When attempting to do so this error comes up

Row cannot be located for updating, some values may have changed since last read

Any way to fix this without having to restore the full database? =/

 

[Ardbeg]

Edits often fail on excel when the spreadsheet is locked due to it being open by another user. (or assumed to be)

 

[Geordiehc]

no its not a proplem with excel its a problem with SQL, i googled and it said its caused by something wrong with the 'Primary Key' ??

 

[JealY]

'Primary Key' ??

My old college tutor would kick you in the face for that.

 

[Tai]

yeah cmon geo this is gcse level stuff

 

[Geordiehc]

A) didnt do GCSE's
B) if its simple then please tlel me... dont wanna have to start everything again from scratch

 

[mapafail]

Think about it a little Paul!

"The primary key of a relational table uniquely identifies each record in the table"

Excel - SQL cause's a secondary key to be added.

 

[Geordiehc]

i dont think this problem has anything to do with excel =/ it was knackered before i done anything with it, the STD_Magic db got edited and now can tbe edited again

 

[mapafail]

i dont think this problem has anything to do with excel =/ it was knackered before i done anything with it, the STD_Magic db got edited and now can tbe edited again

You need to go from top to bottom of the entire database and check the ID number of everything, as you will find you have a duplicate entry and if your using 2000 you might have to delete all entries in the database up to the point of the duplicate.

As for Excel - SQL import/export = This works fine when exporting out the database, but when you import the database back in, if you don't add a certain entry in Excel to import correctly, it corrupts your whole database.

 

[Geordiehc]

But there are no ID numbers and no ID's have been changed :/

 

[mapafail]

The IDX is your primary, you know the numbers that run up the side from 1 - what ever your last one is, come on Paul this is easy stuff.

 

[Geordiehc]

well they are al in order.... what can i do to fix this?

---------- Post added 01-05-2012 at 03:33 PM ---------- Previous post was 30-04-2012 at 06:05 PM ----------

bumppppp

 

[mapafail]

well they are al in order.... what can i do to fix this?

---------- Post added 01-05-2012 at 03:33 PM ---------- Previous post was 30-04-2012 at 06:05 PM ----------

bumppppp

If it's still not allowing to be edited, then the only thing I could suggest, is to import the Magic Database. You don't need to do all the database, just import the magic db and over wright the original.

 

[Breezer]

What version of Excel are you using?

 

[Geordiehc]

If it's still not allowing to be edited, then the only thing I could suggest, is to import the Magic Database. You don't need to do all the database, just import the magic db and over wright the original.

ahh right i didnt know i could do that, could you explain how please

 

[Breezer]

Never set up mir3 files....maybe this helps?

http://support.microsoft.com/kb/300586