Is Caspio The "Microsoft Access" Of The Cloud? - InformationWeek
Software // Information Management
05:26 PM
David Berlind
David Berlind
Connect Directly
Ransomware: Latest Developments & How to Defend Against Them
Nov 01, 2017
Ransomware is one of the fastest growing types of malware, and new breeds that escalate quickly ar ...Read More>>

Is Caspio The "Microsoft Access" Of The Cloud?

While it may look and feel like Microsoft Access, is most definitely not Microsoft Access. But it does many of the things that Microsoft Access promises to do for its users, only from the cloud. While at the Cloud Connect conference, Editor-in-Chief David Berlind captured a demo of Caspio on video from the company's CEO Frank Zamani.

Better late than never. While at the Cloud Connect conference at the end of April (2010), I "filmed" a demo of with the company's CEO Frank Zamani. After some delay, here's my writeup and the video (below). To me -- a former database guy (a lot of the software I developed over the years relied on dBase or Microsoft Access databases) -- the demo (video below) looked eerily familiar. It was almost as if I was looking at a cloud-based version of Microsoft Access. In my interview of him, Zamani even admitted "We made it look like Access."

Zamani doesn't pitch Caspio as the Microsoft Access of the cloud. He'd probably get sued for trademark misappropriation. But nothing prevents me from calling it that because that's exactly what it is. In fact, if Microsoft was smart, it would go out and acquire Caspio today so that it could check-off "Access" as one of the applications it will offer in the cloud (in addition to Word, Excel, and PowerPoint). Or maybe Google should acquire the company first (just to keep Microsoft from one-upping Google in terms of the core office applications offered out of the cloud).

I digress.

Says Zamani in the video, "Caspio is an online database platform for developers to build databases without programming. It's an easy way to build Web apps for any Web site, anywhere." And therein lies a big difference between what can be done with a shrink-wrapped locally installed piece of software like Microsoft Access and a cloud-based clone of the same: it can generate Web apps off those databases that look and feel very much like the desktop apps that the locally installed software used to generate.

One of the best features of Caspio is its "embed" feature which offers an embed code for a Caspio-based "datapage" much the same way that YouTube offers embed codes for its videos. Then, it's just a matter of placing that embed code in the HTML for a given page and Voila!; the database you just developed in Caspio is now available on the Web page.

This embedding capability is non-trivial when you think about the sort of code it often takes to pump the results of a database query onto a Web page. Zamani admits that as much as Caspio tried to make its cloud-based database idiot-proof, databases are still a challenge for most to fully grok. "You still need to be tech savvy" said Zamani in the interview. "We provide instructor led sessions on the Web."

In the demo, Zamani shows me how Caspio not only looks like Microsoft Access, it can import databases from Microsoft Access. The whole process is driven by what Zamani calls "Caspio Bridge Wizards." Once a database is imported or created, the next step is to launch a "Datapage Wizard" for creating Web forms, query forms, and reports (query results): basically, all the forms you need to complete an application. Like with Microsoft Access, you can skin the application with different styles and it appears (in the video) to offer localization to a bunch of different languages.

Caspio handles blobs at the field level (in other words, there's support for video, images, and other large binary objects) and supports SQL/API-based access to its databases (as you'd expect any database offering to do).

So why do your database in the cloud? For the same reasons you'd do anything else in the cloud. Let the cloud provider (Caspio in this case but there are other Access-like databases in the cloud) worry about the hardware and the scalability issues so you can stay focused on the value that your business gets out of a database. Not only that, no messy upgrades whenever your software provider decides to patch or upgrade your software. Like with other cloud-based services (eg:, Google, etc.), getting the latest code is simply a matter of refreshing your browser.

Caspio has a personal "version" that's free but is limited to 2 data pages (essentially forms) and then starts at $40 per month for 10 datapages, 1 GB worth of data transfer and 1 GB of storage. There's a corporate version that goes for $350 per month (more datapages, capacity, and "logins") and several levels of subscription in-between. All levels of subscription allow an unlimited number of application users (people who would use the database as a part of a Web page or Web app via the aforementioned embedding feature). Depending on your level of database sophistication, Caspio may or may not be the solution for you. For example, you may find Amazon's SimpleDB to be more cost effective. Then again, it requires more in the way of database savviness and programming capability.

Caspio can be found on the Web at Here's the video demo:

David Berlind is the chief content officer of TechWeb and editor-in-chief of He can be reached at and you also can find him on Twitter and other social networks (see the list below).

Twitter: (@dberlind)
My Facebook Page
Flickr (davidberlind)
YouTube (TechWebTV)

FriendFeed (davidberlind) (dberlind )
Me on LinkedIn
Plaxo (davidberlind)

Disqus (DavidBerlind)
Google Profile (David.Berlind)

Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
User Rank: Apprentice
10/30/2015 | 4:41:50 PM
PaaS is trending
Is there any PaaS software that supports gaming? we tried many PaaS and none of them support games. Other than that i heard good things about all these tools Capsio, Zoho, BizFirst, Knack
User Rank: Apprentice
10/15/2014 | 12:45:13 PM
Great tool for database projects!
Our department had an old Access database that's getting more difficult to maintain every day. We were researching tools to migrate it online and came across Caspio. 

Their user interface is clean and pretty easy to navigate. Customer support is THE BEST: the staff I worked with were all fast in response and very knowledgeable about the product. Helps me out every time! They also have a good amount of video tutorials and articles which I found to be very helpful too.

I would recommend Caspio for all kinds of database-driven applications. 
User Rank: Apprentice
10/11/2014 | 9:25:33 PM
re: Is Caspio The "Microsoft Access" Of The Cloud?
There are now far more modern and elegant cloud-based database solutions. ParaSQL is probably the newest and most modern... it runs entirely in the Google Cloud, has a modern free-form layout design, etc. 
User Rank: Apprentice
1/15/2013 | 8:51:41 PM
re: Is Caspio The "Microsoft Access" Of The Cloud?
This is a sub-par antiquated product. Beware of the pricing model. It is designed to smack you with major overage charges. A lot of folks don't see this coming. Compared to another product like Zoho, Caspio has been stagnate for 12 years, at 50 employees, while Zoho has grown to over 1000 employees. I would put my money on a horse that will be around for a long time... like QuickBase (Intuit) or Zoho.
User Rank: Apprentice
12/19/2011 | 6:17:31 AM
re: Is Caspio The "Microsoft Access" Of The Cloud?
We've recently completed a project to port a MS Access application to the iPad, iPhone and the Cloud. The application helps emergency first responders react quickly to emergencies.

Here is the latest video:

Sasha Froyland
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
2017 State of IT Report
In today's technology-driven world, "innovation" has become a basic expectation. IT leaders are tasked with making technical magic, improving customer experience, and boosting the bottom line -- yet often without any increase to the IT budget. How are organizations striking the balance between new initiatives and cost control? Download our report to learn about the biggest challenges and how savvy IT executives are overcoming them.
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll