External Database Linking

[DBurrows]

We have our website split over 2 pcs, one for site updates and one for order processing, is it possible to externally link the actinic database from the design PC to the orders PC so we can take advantage of stock controll and offline ordering etc?

[Jan]

To do this you would need to create a new Actinic database, link this database to stock control and product reference fields in your actual one. The link the new one to your second PC. You can't link an Actinic database to another Actinic database because the program checks the name of the database to make sure that it isn't an Actinic database but using a separate one to link through might well work.

You can't link all of the field through external linking (eg the section structure) so some parts would have to be mirrored using a snapshots every now and again.

Regards,

[Marci]

We operate as you're describing, and have just linked Address, Catalog Section1, Landlord Adjustment, Order, OrderDetail, OrderMail, OrderTracking, PaymentHistory, Person and Product tables. (Share Site1 directory on each machine then just use linked table manager)

This doesn't allow stock control - have a feeling need to link ProductProperties for that just never got round to it...

Am currently trying to decide how things'd run if I upsized it all to a MySQL dbase then setup actinic to look to the MySQL dbase via DSN... to allow php integration... but beyond my knowledge at the mo.