ECatsBlog
  • Home
  • Web Dev
  • Reviews
  • Thoughts
  • ASP
  • SQL
  • Browser
  • Mobile
  • Cloud
  • CMS
  • ECommerce
  • App Hacks
  • Fixes
  • Mapping
  • 3D Printing
  • XAML
  • SEO

Categories

  • 3D Printing (1)
  • App Hacks (4)
  • ASP (20)
  • Browser (12)
  • Cloud (10)
  • CMS (7)
  • ECommerce (6)
  • Fixes (3)
  • Mapping (1)
  • Mobile (12)
  • Reviews (70)
  • SEO (9)
  • SQL (12)
  • Thoughts (59)
  • Uncategorized (1)
  • Web Dev (92)
  • XAML (9)

Archives

  • February 2022 (1)
  • June 2019 (1)
  • January 2019 (175)
  • December 2018 (47)

Access updates

When Written: July 2006

Often with clients I find that they like to maintain their company data with Microsoft Access. However their web server will be running something like MySQL which is much better suited to handling the number of requests that might occur out on the web rather than using Access which really should be considered a desktop database, albeit a very flexible one.

So there is a need in such situations to syncronise the office-based access database with the MySQL  data on the web server. Whilst many of us might ‘roll our own’ solution, one ready made one was brought to my attention by Richard Palmer of Blackbird Solutions. This product is called Access2MySQL Sync (http://www.data-conversions.net/index.php) and it does what it ‘says on the tin’ , there are evaluation versions on their web site so you can try before you buy. The product has a scheduler package as well so you can set up time schedules to synchronise your data automatically.

Article by: Mark Newton
Published in: Mark Newton

  • Previous Web Advertising3 years ago
  • Next Commas cause Chaos3 years ago

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • SMTP Email Client
  • IIS8 SMTP setup
  • 3D printing the Ness of Brodgar
  • Which phone is best?
  • Mobile Apps

Recent Comments

  • Quality assurance services on Windows 10 phone and HERE Maps – Fixed!
  • HP Deskjet 3755 Wireless Printer Setup on Windows 10 phone and HERE Maps – Fixed!
2022 ECatsBlog. Donna Theme powered by WordPress