table difference...

[burnside]

...a couple of days ago the companies access db crashed.
when i went to look at the tables the message
["" is not a unique identifier] was displayed.
i tried for hours using all the tricks i could think of to get it to open, but in the end gave up and bought a program called advanced access repair which managed to get the tables back.

I copied the main table into a new 'shell' and thought the nightmare was over.

However, i realise all is not well because when a new record is created the code that puts 0 in the fields on a form does not work and the code that works VAT out only kicks in if you save the record and go back into it.

now i started blaming the code/forms etc, but if i replace the table with a previous backups it works fine.
both tables look the same [design wise], they are called the same i cant see any difference [apart from the content] which shouldnt matter because this is a New record.

this is really bugging me.
im using access 97.

any ideas welcome
cheers MG

backups will save your soul

 

[burnside]

oops the error i was getting when looking at tables is

"operation invalid without a current index"

and when tryin to look at forms/queries

" isnt an index in this table

 

[sleeGomembers]

Dear Burnside:

I have this same problem, too. I found a link with code that purports to fix Access MDBs with just such a problem. Only issue is that the code throws and error and the problem still remains. I'm not sure at what point the code errors although I suspect it's at the very end when the objects have already come over to the new mdb. You may want to try this for yourself and see if you have any luck with it.

Here's the link:

http://www.dbforums.com/showthread.php?t=1055231

 

[burnside]

thanks - cant rememeber what i did will try this if it happens again