Suunto Dive Manager - anyone know the database password?

[dave archer]

Sunnto Dive Manager has managed to corrupt it's database on my desktop.

I want to open the d9.mdb file in MS Acess to try to correct whatever the problem is, but it's password protected

Quick google has not turned up the answer - anyone know the password?

Thanks,
Dave.

[RonProwse]

look for a access password remover on the net that should be able to unprotect it for you

Ron

[JonP]

The password is Koira (which is Swedish for wolf or some such thing).

[lloydwatkin]

Ask Suunto they're usually quite helpful with these things

[dave archer]

Originally Posted by JonP

The password is Koira (which is Swedish for wolf or some such thing).

I can't try this out until tomorrow (MS Access at work only) but if correct, then you sir are a complete star!

Thanks very much! Green ahoy!

Dave

[aquayle]

Originally Posted by JonP

The password is Koira (which is Swedish for wolf or some such thing).

it is actually koira (case sensitive)

[lloydwatkin]

Originally Posted by dave archer

I can't try this out until tomorrow (MS Access at work only) but if correct, then you sir are a complete star!

Thanks very much! Green ahoy!

Dave

Worked for me. Interesting stuff, cheers!

[dave archer]

Originally Posted by aquayle

it is actually koira (case sensitive)

It is indeed!

Excellent stuff thanks. At least I have half a chance of working out what's wrong with the data and being able to use it again..

Cheers all,
Dave

[String]

Thread bump here.

Has anyone got any information about the structure of this database.

Despite getting it open in access i cant make head nor tail of the structure it uses to store information. I was hoping to write a script to parse it to create my own log programme but the DB design itself seems somewhat random and to me at least very confusing.

[JonP]

The DB design is indeed somewhat, er, random (for want of a better word). Here's what I worked out when I was messing about trying to write my own reports for it:

Firstly nearly all the data, no matter what type is stuffed into the same main table. I think it was called items. You have to look at the record type field to work out what is what. It's fairly obvious when you look through the data.

Having sorted the right record type for the dive data (which is what I was after), I worked out the following fields:

icustom11 = dive no.
t_custom3=location
t_custom4=location2
t_custom6=boat
t_custom8=buddy
t_custom9=dive master
t_custom10=vis
t_custom11=weather
i_custom13=temp at start of dive
i_custom14=temp at max depth
i_custom15=temp at end of dive
i_custom_18=no of alarms (?)
i_custom4=sample rate
i_custom8=mix%
d_custom9=max depth
d_custom10=average depth
d_custom11=cylinder size
d_custom1=surface interval (seconds)

Some other fields had meaningful names, and there are separate tables for kit, bookmarks and profile data if I remember rightly. Profile data table was called trackpoints I think. Can't remember which field linked the data there to the record in the items table, but it should be easy enough to spot if you look at it.

That will give you a rough (and I mean rough) idea.

Anyway - that's what I think they are. Didn't work out all of them. If you need more I'll have to open it up again and refresh my memory. Been a while since I last looked at it.