v9 will not load - faulty database

[dalglish44]

Hi
I am using v9 on a trial basis until I upgrade from v7.
After a week, I know have the following message on startup which refuses to load the v9 ... what would be the best thing to do?
I have v7 with my products safely backed up so could afford a clean install of v9 if that was required ...
There was a problem with the database

Operation: Opening the SELECT [Checkout Prompt].[nID],[Checkout Prompt].[nPhase],[Checkout Prompt].[nStatus],[Checkout Prompt].[sLanguage],[Checkout Prompt].[nTabGroup],[Checkout Prompt].[nTabSubGroup],[Checkout Prompt].[nUIMask],[Checkout Prompt].[nDefaultStatus],[Checkout Prompt].[sPromptDescription],[Checkout Prompt].[dSequence],[Checkout Prompt].[nUploadStatus],[Checkout Prompt].[sPrompt],[Checkout Prompt].[sDefault], [Checkout Prompt].[sName], [Checkout Prompt].[sDescription], [Variable].[sName],[Variable].[sDescription], [Variable].[sPrompt] FROM [Checkout Prompt] LEFT OUTER JOIN [Variable] ON ([Checkout Prompt].[nID] = [Variable].[nValueID] AND [Checkout Prompt].[nPhase] = [Variable].[nValueSubID] AND [Variable].[nValueSubSubID] = 0 AND [Variable].[nValueDB] = 0) table where [Checkout Prompt].[nPhase] = -1 AND [Checkout Prompt].[nID] = 135 AND [Checkout Prompt].[sLanguage] = 'eng-uk'

The Microsoft Jet database engine cannot find the input table or query 'Variable'. Make sure it exists and that its name is spelled correctly.

Action: Contact your Actinic reseller or Actinic Support as appropriate

[Duncan Rounding]

I think your best bet is to uninstall v9 then reinstall it again and then import your latest v9 snapshot. Make regular snapshots, especially whilst in the 'learning curve'.

[dalglish44]

many thanks Duncan
great advice
Steve