Announcement

Collapse
No announcement yet.

ODBC or DSN-less connections to Access

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

    ODBC or DSN-less connections to Access

    Is it possible to create a DSN-less connection with Actinic as oppossed to an ODBC one? Also is it possible to connect to a remote database which is held on a different virtual server? the Reason for doing this is to avoid having several databases scattered around. I am using Access 2000 and act business.

    #2
    I'm afraid I don't know the answer to this one. You could try raising a support question HERE as the email support team will be able to contact the development team and maybe get some suggestions.

    Comment


      #3
      You need an ODBC connection to connect to Actinic, internally it uses DAO and ODBC. However ODBC can connect to databases that are not on your local server so you should be able to set one up that connects to a database on an external machine.

      Actinic will only work on one machine at a time (although you can run it on several so long as only one is in use at any one time or you have separated out order processing and catalog maintenance - and you might need several licenses to do this).

      If you can access your virtual machine and set up an ODBC connection to it then Actinic should work so long as you have installed it at the location you are working from (before changing the ODBC connections.)

      Actinic's current upgrade system modified tables using SQL rather than overwriting the current database so you could add tables to the Actinic database to centralise your systems.

      Regards,
      Jan Strassen, Mole End Software - Plugins and Reports for Actinic V4 to V11, Sellerdeck V11 to V2018, Sellerdeck Cloud
      Visit our facebook page for the latest news and special offers from Mole End

      Top Quality Integrated label paper for Actinic and Sellerdeck
      A4 Paper with one or two peel off labels, free reports available for our customers
      Product Mash for Sellerdeck
      Link to Google Shopping and other channels, increase sales traffic, prices from £29.95
      Multichannel order processing
      Process Actinic, Sellerdeck, Amazon, Ebay, Playtrade orders with a single program, low cost lite version now available from £19.95

      Comment

      Working...
      X