Microsoft Access is
basically a database application on the desktop. Where as, Zoho Creator is a
powerful, scalable, and secure cloud computing platform that lets you
build and run database applications online. Some of our users call it
as ‘Microsoft Access + Visual Basic for the web‘ (Sorry, PDF).
So, what happens when you migrate data from Microsoft Access to Zoho
Creator? Well, it can become a powerful web application. This is
basically what we are doing with our announcement today. We are excited
to announce the latest addition to our family of Microsoft plug-ins – Zoho Plug-in for Microsoft Access (EXE link).


Two weeks back, we integrated our collaborative productivity applications into Microsoft SharePoint. Last week, our project management application added the capability to import your existing projects from MS Project to Zoho Projects 2.0. This week, we have a new add-on that imports your data effortlessly from Microsoft Access to Zoho Creator and Zoho Reports and does much more.


So,
what happens when you migrate your database (MDB file) from Microsoft
Access to Zoho Creator? Your entire database structure and data are
migrated to Zoho Creator and an application is automatically created
with Forms (Tables) and Views etc. This is a quick way of creating a
web-based collaborative database app from your non-collaborative
Microsoft Access DB. Once the Microsoft Access DB is migrated to Zoho
Creator, the collaborative aspects kick in where the entire
application (or parts of it) can be shared with multiple users.

To summarize the core functionality of this plug-in in three short points, this is what it does…

  • Migrates your Database from Microsoft Access (MDB File) to Zoho Creator & Zoho Reports
  • Automatically creates a web-based database app from your Microsoft Access database &
  • Allows you to share your applications with others

This video will give you a good idea on how this works…


Also check out: Why you should migrate from MS Access to Zoho Creator

Zoho
Creator platform offers more flexibility for your applications. Once
you have your app migrated from your MDB file, you can edit your
existing application online and can also add additional business logic
using Deluge Script,
our scripting language. The power of Deluge Script makes it easy to
design business workflows and perform a variety of automated actions
based on the criteria specified. If you have your app created and if
you are not a Creator expert, but want to take advantage of our
advanced functionality, we have many developers in our community who
are willing to help you with your app. If you think your migrated
application can be valuable for other users, you can also sell your
application in Zoho Marketplace.

Once you have your app created in Zoho Creator, it can also be deployed onto Google AppEngine.

Migrate Microsoft Access DB to Zoho Reports:

This migration tool not only imports your data to Zoho Creator, but it can also import the data to Zoho Reports, our Online Business Intelligence tool that lets you analyze your data and create powerful reports including charts, pivot tables, dashboards etc. Once you have your data imported from Access, similar tables are automatically created in Zoho Reports and are available for analysis.

This
Migration tool is available for free. So whether you want to create a
web-based database app from your existing data, or analyze your data or
share it with others, this migration tool makes it extremely easy.


We certainly hope you’ll find this tool useful. As usual, we can’t wait
to see the amazing apps you build on our Zoho Creator platform.

  1. Amanda90

    Zoho creator is definitely one of the best tools for web application developing out there. I have checked many of them but they lack one or other thing. Zoho creator is the best one for sure. I am developing a mp4 converter at the moment so Zoho creator will definitely help me in some ways. Thanks for publishing this article here by the way.

  2. Amanda90

    Zoho creator is definitely one of the best tools for web application developing out there. I have checked many of them but they lack one or other thing. Zoho creator is the best one for sure. I am developing a mp4 converter at the moment so Zoho creator will definitely help me in some ways. Thanks for publishing this article here by the way.

  3. civambio

    HelloWe couldn’t import a .mdb file to Zoho Creator. The program says :
    Problem encountered while creating the application IAMError:Z101:Invalid_Ticket
    This is with win XP.
    And with Ubuntu or Archlinux, we doesn’t find the good tool to migrate the files. Is there a solution ? Thanks a lot for your answer and for your great tools.Jerome (France)

  4. civambio

    HelloWe couldn’t import a .mdb file to Zoho Creator. The program says :
    Problem encountered while creating the application IAMError:Z101:Invalid_Ticket
    This is with win XP.
    And with Ubuntu or Archlinux, we doesn’t find the good tool to migrate the files. Is there a solution ? Thanks a lot for your answer and for your great tools.Jerome (France)

  5. Yoge

    ramonaortega:We found an application migrated from MS-Access db created in your account. We have sent you a detailed email regarding the issue. Please get back to us for further clarifications. Sorry for the inconvenience caused.–Yoge

  6. Yoge

    ramonaortega:We found an application migrated from MS-Access db created in your account. We have sent you a detailed email regarding the issue. Please get back to us for further clarifications. Sorry for the inconvenience caused.–Yoge

  7. ramonaortega

    tried to do migration with client and got message “exception occured” data model topic????Please help

  8. ramonaortega

    tried to do migration with client and got message “exception occured” data model topic????Please help

  9. Rodrigo Vaca

    Oliver -Currently we have two deployment options:When your Creator application is ready, you can use it in Zoho’s servers. If you don’t want to do that, you can also take your App and deploy it to Google’s AppEngine. Now, that will take a little more work and knowledge from your side, but that’s also that can be done too.Finally – more than a million people trust Zoho with their data on a daily basis. You can read more about how your data is secure at Zoho at: http://blogs.zoho.com/general/…Rodrigo

  10. Rodrigo Vaca

    Oliver -Currently we have two deployment options:When your Creator application is ready, you can use it in Zoho’s servers. If you don’t want to do that, you can also take your App and deploy it to Google’s AppEngine. Now, that will take a little more work and knowledge from your side, but that’s also that can be done too.Finally – more than a million people trust Zoho with their data on a daily basis. You can read more about how your data is secure at Zoho at: http://blogs.zoho.com/general/…Rodrigo

  11. Oliver R.

    Wow, looks awesome.Only question I have: is Zoho Creator available to use in the Intranet on our own server? Because I do no want to upload any of our business data to your servers… :)Thanks,
    Oliver

  12. Oliver R.

    Wow, looks awesome.Only question I have: is Zoho Creator available to use in the Intranet on our own server? Because I do no want to upload any of our business data to your servers… :)Thanks,
    Oliver

  13. Jane McCarty

    Tried to create it from standard database and failed!#….

  14. Jane McCarty

    Tried to create it from standard database and failed!#….

  15. __Yoge__

    @endomanYes,the tool supports migration of access 2007 dbs(.accdb)

  16. __Yoge__

    @endomanYes,the tool supports migration of access 2007 dbs(.accdb)

  17. endoman

    Fantastic. I have been waiting for something like this to come around for a while now. Does the migration tool support .aacdb databases ie Access 2007?

  18. endoman

    Fantastic. I have been waiting for something like this to come around for a while now. Does the migration tool support .aacdb databases ie Access 2007?

  19. drewhyde

    Can everyone please look at the camera and say “killer app”. Congratulations zoho team.

  20. drewhyde

    Can everyone please look at the camera and say “killer app”. Congratulations zoho team.

  21. Didier

    Guys,
    You’re incredible at Zoho!

  22. Didier

    Guys,
    You’re incredible at Zoho!