CODEWITHSUNDEEP
databasems-accessportable-database
lamcro
lamcro

Reputation: 6281

Alternatives to Access

Are there any alternatives to MS Access?

Requirements:

Two more requirements:

Upvotes: 15

Views: 4349

Answers (11)

Craig Mc
Craig Mc

Reputation: 505

Check out Filemaker

Upvotes: 2

ChrisLively
ChrisLively

Reputation: 88074

Your options seem to be:

  1. SQL Server Express. This used to be called the MSDE

  2. SQL Server Compact Edition.

  3. MySQL.

  4. SQLite.

  5. VistaDB.

==========

I'm modifying this to add the only real contender I've found: Kexi

http://kexi-project.org/

I can't say that I've used it, but it looks like it will do everything you want.

Upvotes: 9

Konstantin Tarkus
Konstantin Tarkus

Reputation: 38378

VistaDB is the only alternative if you going to run your website at shared hosting (almost all of them won't let you run your websites under Full Trust mode) and also if you need simple x-copy deployment enabled website.

Upvotes: 0

Joshery
Joshery

Reputation: 345

I've done a lot of MS-Access development and from a form design standpoint or RAD (rapid application development) standpoint it's hard to beat.

However you can use MS-Access in conjunction with another Database Server that will give you flexibility down the road. My suggestion would be to use Sybase Advantage Database Server. I'm a bit biased as I support the product but we have a free Local server version for you to try out and later you can implement a full client/server setup by simply changing the connection. Advantage DevZone

In the case that you use another database engine you will likely be using ODBC for your connection type which Advantage supports along with JDBC, OLEDB, .NET, PHP, etc.

Upvotes: 4

warren
warren

Reputation: 33455

I've used 4th Dimension in the past. I don't know, however, if it requires compilation - but it can be compiled.

But its design features are extremely friendly in my opinion.

Upvotes: 1

Galwegian
Galwegian

Reputation: 42237

SQLite is awesome.

Upvotes: -2

Onorio Catenacci
Onorio Catenacci

Reputation: 15293

Possibly you missed this Q & A when you searched the site for an answer to this question. You may find some good options there too.

Upvotes: 4

Aaron Maenpaa
Aaron Maenpaa

Reputation: 122910

SQLite is always my choice for lightweight databases, though it doesn't have a form creator as it's just a database.

SQLite is great because:

  • It's just a library to be called by your application, not a server.
  • There's no configuration.
  • Your database is just a file.

(... and you can use in memory databases for testing, for those addicted to unit tests :)

Upvotes: 5

acrosman
acrosman

Reputation: 12900

FileMaker meets your requirements, although it is not something that I would recommend for collaborative development.

Upvotes: 3

MBoy
MBoy

Reputation: 704

There used to be an awesome product for dos called Q&A this became http://www.lantica.com/ but I haven't looked at it since the dos version.

Alternatively try this wiki page http://en.wikipedia.org/wiki/Comparison_of_office_suites there are some tables of comparisons near the bottom.

Upvotes: 0

mmacaulay
mmacaulay

Reputation: 3029

The one that comes with OpenOffice might be what you're looking for, it's called "Base" I believe: http://dba.openoffice.org

I voted for zacherates because I like SQLite too, though.

Upvotes: 9

Related Questions