Announcement

Collapse
No announcement yet.

load up the database and access product titles, descriptions etc

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

    load up the database and access product titles, descriptions etc

    I just wondered if there was a quick way to edit the product titles by loading up the database? If so where abouts in the database are they?

    ta

    #2
    If you remember to backup the database (or take a snapshot - which will include the database) before you open it (every time), then it can be done.

    Product details are in the product table. When you do screw things up (and you likely will if you are not used to working with Actinic Access files) just copy your backup over the top of the messed up database or import your snapshot.
    Bill
    www.egyptianwonders.co.uk
    Text directoryWorldwide Actinic(TM) shops
    BC Ness Solutions Support services, custom software
    Registered Microsoft™ Partner (ISV)
    VoIP UK: 0131 208 0605
    Located: Alexandria, EGYPT

    Comment


      #3
      Nicholas - much easier/better/safer to link to an external Excel worksheet using File/External Links for this (plus you can use Excel's text functions such as concatenate and substitute - replace underscores with hyphens very quickly). Also for other items such as price, eg knock 20% off all prices for 2000 products in about 30 seconds

      Aquazuro - designer stainless steel accessories

      Comment

      Working...
      X