Files damaged in Catalog, need help repairing

[hhtowne]

Unfortunately, I'm not much of a wizard and I have had some trouble. I need help.

My website is running just fine, but within Actinic on my desktop, I was starting to add a link to a YouTube video. Under 'links' on my desktop, I pasted the embedded code without adding the !! at either end. I now get an alert box 'data truncated' and many of my fragments seem to have disappeared.

Fortunately, I have not uploaded the broken site to the web. However, the broken site backed up automatically. When I open it, it will not work properly.

My husband helped me to .tar the correct site online. I know three of the files that were changed: Backup.mdb, actinic.css and P_Links.html.

I have tried to restore just actinic.css and P_Links.html from a previous backup, and that did no good whatsoever, still get 'data truncated' error message, so I deleted the restored files and renamed the originals.

I want to bring the good site down to my desktop, but I cannot figure out how. I am fearful of doing anything with the backup.mdb file. Can someone please advise me?

I do have an appropriate .acd file from 01/08, but I am fearful that I will lose the sales I've had since then.

Actinic Developer, Version 6.

Thank you,
hht

[gabrielcrowe]

solutions:

1- Export your sales, import the snapshot, import your sales.
2- ActinicCatalog.mdb is damaged, replace that.

ActinicCatalog.mdb is the file that contains your shop data. be careful with it.

[NormanRouxel]

If you were pasting that code into a Product - presumably in the long description, then you may be able to repair it by looking in the Product table in ActinicCatalog.mdb. You'll need Access and some Access skills to do this. Backup that file before tinkerimg.

[hhtowne]

Restored to working order

I think I got it fixed following a comment from Jan at Mole End on how to back up a copy of the database, then restore from a previous .asd file. It included compact and restore. The changes I'd made were minimal, so it was easy to restore it to good working order. I got the youtube links to work as well. http://www.cholo.com/acatalog/Links.html

I had no idea that you could edit ActinicCatalog.mdb in Access. I was working in a fragment when I blew it up,

Thanks to Gabriel and Norman. I'm learning, a little less stupid.

hht

If you were pasting that code into a Product - presumably in the long description, then you may be able to repair it by looking in the Product table in ActinicCatalog.mdb. You'll need Access and some Access skills to do this. Backup that file before tinkerimg.

[amex32]

re:catalog need repairing

It may be possible your files are corrupted due to virus attack or accessing a file on wrong programs. To fix this first you make a backup copy of that mdb file and open it in Microsoft access. Now go to tool option and run compact and repair utility. Your mdb file will work fine or you can use Access repair tool. You can search Stellar Phoenix access recovery software on internet; this will fix the error and repair your backup.mdb file.