Question: MS Access-equivalent Database

From: direstraits (donyc_at_yahoo.com)
Date: 10/03/03 

Date: 3 Oct 2003 03:52:24 -0700

Hi all...

I'm looking for an MS Access equivalent database solution for my Java
application. My equivalent I mean the database is contained in a
single file, i.e. mdb file (where I can distribute the application
with the single MDB for the application to work). It should support
SQL and all the rest of it, but no fancy stuff like triggers are
needed.

The reason I don't use Access mdb itself is because the internals of
Access can change between Office versions (like the one between Access
95 and Access 97/2000), and I don't want the situation where I
suddenly find myself with a database that's outdated and
un-upgradable.

If there isn't a direct equivalent, what database would you recommend
for an application that runs in a client PC (no client-server
mumbo-jumbo here) that requires data that is stored in a database.

In my research I've looked at HSQLDB. I've just downloaded it and
haven't evaluated it yet to see if it fits my requirements.

Thanks in advance for any help you can give!

Donny

Relevant Pages

  • Re: dbGonazles database for Delphi, Kylix and C++Builder
    ... And this is where the Access violation popped out on the Client side. ... the database is still intact and does not need any repair. ... >>dbGonzales is a high speed object oriented client/server database. ... >>This demo is a single file and includes an embedded dbGonzales server ...
    (borland.public.delphi.thirdpartytools.general)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: Access 2000 database and Office XP compatability?
    ... It also means that after developing in A2002, an A2000 MDB will be ... Then compact the database. ... rather than allenbrowne at mvps dot org. ... >A client has just successfully upgraded from Access 97 to 2000. ...
    (comp.databases.ms-access)
  • Re: temp db
    ... If the database is not in use, you can create a copy just by copying the MDB ... The purpose is to create a temp db for all the ... ' This subroutine illustrates how to use a temporary MDB in your app. ...
    (microsoft.public.access.formscoding)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)