URGENT HELP MS ACCESS Corrupt and passworded

[shocker-z]

Hi all work's database suddenly just corrupted it self today and now reckons it has a password on it..

anyone got a good recovery utility or know of a repair that may work?


Liam

[BliarOut]

Sticking access password in Google came up with this

www.tucows.com/preview/356456


Copy the database somewhere else first and give it a whirl.

[shocker-z]

no joy as it's shareware..

[roadsweeper]

Have you tried the built-in Access repair function? (I seem to recall there is one)

[FunkyGibbon]

www.oxid.it/cain.html

has an access mdb password tool

[shocker-z]

right i found a tool after perswading it it's mine that got the password which is well and truely corrupt!

the password showed as: 뗏箯Ĕ껒细예阳䂪둴ᙛ動釿푗挳迯埰࡙嬗閲ੜ턥륜㬡�漲둪Ṍـ땿ҩ

hmmmm

ran repair but keeps saying it is an unrecconised database format.

anyone know of any good database repair software?


Liam

[plasticpig]

In my admittedly limited experience of recovering Access DB files if the standard tools with Access wont fix it then you are better off restoring from backup. You do have a backup don't you?

[SneakyNeil]

Try Jetcomp, I've had quite good success where access wouldn't open the file.

Also, I had a huge one once where newish versions of access wouldn't open it, but an old version did open & repair it. Might have been 97 or 2K.

If you manage to repair it, check the data very carefully afterwards. Check totals, check random records, go back as far as you can.


If jetcomp fails, its restore time. Infact, if you've got a backup just restore anyway - its quicker and more certain!

Eta: 'Ave it! Gew on lad, get in.

Edited by SneakyNeil on Monday 8th January 18:09

[shocker-z]

UPDATE
We managed to recover it but all autonumbers have changed top number.. anyone know of anyway to change this as oviusly access wont let us change..

We're talking bout a database with over 100 relations


and Plasticpig unfortunately our last backup was a month ago.. being a typical IT company we never get round to resolving our own issues..

Oh i tryed jetcomp but no joy

Liam

Edited by shocker-z on Tuesday 9th January 09:57

[V8 EOL]

You could try sucking the data out using a ODBC/JET/OLEDB connection?

Are you running SQL Server anywhere? It ships with a DTS package that easily enables data transfer from one DB to another...

[sneakyneil]

shocker-z said:

UPDATE
We managed to recover it but all autonumbers have changed top number.. anyone know of anyway to change this as oviusly access wont let us change..

We're talking bout a database with over 100 relations


and Plasticpig unfortunately our last backup was a month ago.. being a typical IT company we never get round to resolving our own issues..

Oh i tryed jetcomp but no joy

Liam

Edited by shocker-z on Tuesday 9th January 09:57

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

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

To be fair, we only take backups once a week..

Edited by sneakyneil on Tuesday 9th January 10:28

[shocker-z]

thanks for the reply but we can't actualy set the field to autonumber in the first place.. so reseting the autonumber is really the step after

[sneakyneil]

You'd better get typing m8

[scissorhands83]

EDIT: This is shocker-z but my brother must have stole my PC for a while that's why it's under scissorhands83


haha

FIXED

used officerecovery suite and it repaired it as well as autonumber field. on my travels i found possibly the best microsoft artical which read along the lines of


CAUSE
This is cause by your MS Access database being opened a non MS Access program

RESOLUTION
Don't open in a non MS Access program!


I was like well yeah thats what you shouldn't do but it's not a FIX!

Cheers for the help, it is muchley appreciated

Liam

Edited by scissorhands83 on Tuesday 9th January 21:14

[shocker-z]

Grrr bloody brother! wonderd why he had replied lol

Anyway had too much confusion today! laters


Liam