Microsoft Access to Caspio conversion tutorial?

[RJArcher]

There must be other Caspio developers who, like me, are trying to migrate their apps from Microsoft Access to Caspio. Is there a forum that I haven't found that might contain, tips, tricks and taboos for migrating existing Access apps? Obviously, getting the data across is a piece of cake, but what about recreating complex queries as Caspio Views and things like that?

[ChrisCarlson]

RJArcher,

There is not a particular forum for MSAccess Database conversion.

I have converted several Microsoft Access databases before. Caspio has been a great tool to convert legacy access databases into online web applications. It is much more stable than MSAccess. Some examples include you can authenticate access better, you don't have to worry about issues like the file getting corrupted, and you can avoid record locking issues.

Caspio previously had a data import option that would allow you to import MSAccess files under MSAccess file type directly into Caspio, but it was only for table import data. Since that feature has been deprecated, you import data via other formats (csv, text tab delimited, excel, etc).

For MSAccess databases, you will need to manually re-create the Access Database in Caspio. Once you are familiar with all of the features in Caspio, you can emulate the MSAccess database structure with comparable features in Caspio.

Here is a list of MSAccess functions and their equivalent function(s) in Caspio:

• Tables in MSAccess = Tables in Caspio
• Queries in MSAccess  = Views in Caspio
• Forms in MSAccess = Datapages in Caspio
• Reports in MSAccess = Datapages in Caspio
• VB Scripts in MSAccess = Caspio table formulas, datapage calculations, triggered actions in tables * and tasks *, and UI scripting such as Javascript/Jquery **

* as long as you have selected a Caspio account that includes those features or have added on those resources to your account.

** Javascript/Jquery may be needed  depending on complexity of your existing MSAccess Database, but in some cases you can achieve equivalent functionality using Caspio's built in features like triggered actions and tasks. Caspio's introduction of triggered action and tasks in recent years has reduced the need to resolve via scripting.

You can find online documentation here converting MSAccess databases:

https://www.caspio.com/use-cases/migrate-microsoft-access-online/