Actinic Business Data Look up

[Charlie2]

Hi

Just had tried to use "Actinic Business" linked to MS-SQL server. Worked fine but the product appear as "uncategorised" in the apps and it appears you have to drag them into a "section" for them to be downloaded to the web site.

This has the effect of
1) making a copy from MS-SQL server to Actinic own Access database (what a daft idea!!!) which takes for ever
2) The whole thing get sent to the web site as a huge html file and .dat file

Is there a way to get "Actinic Business" to not make a copy in Access as this takes for ever on a large PLU files? And Is there a way to get "Actinic Business" web file to query the MS-SQL server instead of those flat files?

Thanks in advance

C

[Jan]

Actinic takes a copy of the data initial to create the product records in Actinic (because only part of the data comes from the extermal source and you can switch linking on and off as you wish), it then links through to external database to pick up changes. It also recopies the data when you print certain reports, so if you have a large amount of data then this could be a slow process for you.

If it is too slow you might be better off exporting your data from your SQL server database into an Actinic format import file and then just linking the fields that need to be updated from Actinic - such as stock level fields.

Regards,