Announcement

Collapse
No announcement yet.

Crashed pc - now won't open actinic

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Crashed pc - now won't open actinic

    Hi there
    Very grateful for any help - very panicked by this.
    My computer just crashed, and when I restarted, it won't open actinic, saying:

    There was a problem with the database

    Operation: Executing the query ' SELECT Product.*, [Catalog section].[Section text] INTO tempOrphanDuplicateQuery FROM (Product LEFT JOIN Product AS ProductParent ON Product.sOriginalProdRef = ProductParent.[Product Reference]) LEFT JOIN [Catalog section] ON Product.nParentSectionID = [Catalog section].nSectionID WHERE (((ProductParent.[Product Reference]) Is Null) AND ((Product.nProductType)= 1));'

    Database name: \\.psf\Home\Documents\Actinic v9\Sites\Site1\ActinicCatalog

    Table 'tempOrphanDuplicateQuery' already exists.

    Action: Contact your Actinic reseller or Actinic Support as appropriate

    Please help - we had about 50 orders over the weekend, and latest snapshot was early last week.

    #2
    First things first. Make a copy of your complete Site1 directory and take it off that PC - the PC may be on it's way out.
    If you have Microsoft Access you can try a database repair and compact which may fix it if not then you're probably going to have to import your last snapshot. At least you will be able to get your orders even if the catalog is not up to date.

    Sorry to state the obvious but you really must make regular snapshots as well as install backup software such as Acronis or similar to safeguard your data.

    Comment

    Working...
    X