Fragment

[guccij]

Oh dear. You didn't back up? Have you a snapshot anywhere?

[Faulkds]

I have a backup ... The problem is creating fragments and the database crashes...

I have imported my products into a blank database but dont want to have to reconfigure my catalog from the start.

I really want to sort out the fragment issue but I dont know where to start.

I have compacted etc but no luck..


The problem isnt in the product table it lies somewhere else

[malbro]

OK,

What i have done is exported my catalog to file....

Deleted the access database and replaced it with the original...

All is now fine...

Problem is now ive lost all my catalog settings e.g term and conditions, payment methods etc.

Is there a way of exporting the catalog details with out the product details from the database.

I dont want to have to re enter all the details

Hi Darren

If you have access then you could copy the relevant tables from one database to another

[HowardW]

Hi Darren
The text field in fragments should be a memo field - limited to 65.5k characters. It appears that this field in your database has been converted to a text field - limited to 255 characters.
Go to your original database and open it in Access, open the table BrochureFragments in design view and make sure that the field sFragmentText1 is set to Memo, if it is not, change it, save and then move the database back to your site folder
Regards
Howard

[Faulkds]

Thats done it....

Thank you for your help

[Kiran]

Hi

In case anyone else has the same issue (.i.e.) get the "String data right truncated" error on adding fragments with large amount of text to section pages, the fix is as follows...


1. Open database (ActinicCatalog.mdb) in Access
2. Drilled down to the Product table and open it design view.
3. Locate the field “sFragmentText” and changed the data type to Memo.
4. Save the changes

[jont]

@Darren : You can drag them over from the old database into the new using Access ( i take it you did not actually delete the old ActinicCatalog.mdb but simply moved / renamed!)