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 (3)
  • ASP (19)
  • Browser (12)
  • Cloud (10)
  • CMS (7)
  • ECommerce (6)
  • Fixes (2)
  • Mapping (1)
  • Mobile (12)
  • Reviews (70)
  • SEO (9)
  • SQL (12)
  • Thoughts (59)
  • Uncategorized (1)
  • Web Dev (91)
  • XAML (9)

Archives

  • 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 Advertising2 years ago
  • Next Commas cause Chaos2 years ago

Leave a Reply Cancel reply

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

Recent Posts

  • IIS8 SMTP setup
  • 3D printing the Ness of Brodgar
  • Which phone is best?
  • Mobile Apps
  • HTML5 mobile app dev – part 5

Recent Comments

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