Groups > comp.lang.java.programmer > #28971

Re: Accessing Access database files

From	Martin Gregorie <martin@address-in-sig.invalid>
Newsgroups	comp.lang.java.programmer
Subject	Re: Accessing Access database files
Date	2014-07-06 16:42 +0000
Organization	A noiseless patient Spider
Message-ID	<lpbu98$ivp$1@dont-email.me> (permalink)
References	(3 earlier) <53b4ac9e$0$298$14726298@news.sunsite.dk> <lp38u4$ipm$1@dont-email.me> <53b5bda7$0$294$14726298@news.sunsite.dk> <lp4jvf$nta$1@dont-email.me> <53b972dc$0$291$14726298@news.sunsite.dk>

Show all headers | View raw

On Sun, 06 Jul 2014 12:01:32 -0400, Arne Vajhøj wrote:

> On 7/3/2014 6:03 PM, Martin Gregorie wrote:
>> On Thu, 03 Jul 2014 16:31:33 -0400, Arne Vajhøj wrote:
>>
>>> On 7/3/2014 5:48 AM, Martin Gregorie wrote:
>>>
>>>> What about the JET server?
>>>
>>> Never heard about it.
>>>
>>> Google seems to indicate that it is a Solaris admin tool of some kind.
>>>
>>> What is it?
>>>
>> I think a number of products from different sources share the JET
>> moniker but AFAIK only MS use it for a database engine.
>>
>> Its the database server part of MS Access.
> 
> There are no database server in MS Access. It is embedded database only.
> 
>> More than yo ever wanted to know can be found here:
>> https://en.wikipedia.org/wiki/Microsoft_Access
> 
> That articles not not mention any "JET server" at all. In fact it
> explicit states:
> 
> "Microsoft Access is a file server-based database"
>
This is "no mention at all"?

"Microsoft Access, also known as Microsoft Office Access, is a database 
management system from Microsoft that combines the relational Microsoft 
Jet Database Engine with a graphical user interface and software-
development tools." 
- the first sentence on the page I posted the URL for.

> The data exist in a disk file. Of course you can write Java code that
> can read that file.
>
Of course, and the Java code exists. Jackcess is a Java class library 
that implements low level access to it and UCanAccess is a Java class 
library is a JDBC driver which delegates file access to Jackcess and SQL 
interpretation to the HSQLDB class library.
 
> But MS only supports going through the Jet Engine.
>
Indeed, and very many of the ODBC Access drivers connect to it, though it 
can be quite difficult to understand exactly what any particular driver 
does because descriptions provided by the authors and vendors of third 
party drivers are often anything but clear. I think MS-provided ODBC 
drivers use the JET Database Engine. 

And, since at least some JDBC Access drivers are wrappers for ODBC 
drivers, its safe to say that the same applies to them too. My original 
search, which was probably for "JDBC Access", only found a few commercial 
drivers with eye-watering prices and which failed to say whether or not 
they used the JET Database Engine to handle Access database files.
 

-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |

Thread

Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-01 16:28 +0000
  Re: Accessing Access database files markspace <markspace@nospam.nospam> - 2014-07-01 09:55 -0700
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-01 17:29 +0000
    Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-01 22:49 -0400
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 10:03 +0000
      Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:06 -0400
        Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-03 09:48 +0000
          Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-03 16:31 -0400
            Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-03 22:03 +0000
              Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:01 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 16:42 +0000
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:45 -0400
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:47 -0400
  Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-01 22:47 -0400
    Re: Accessing Access database files markspace <markspace@nospam.nospam> - 2014-07-01 20:11 -0700
      Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:05 -0400
  Re: Accessing Access database files Gordon Levi <gordon@address.invalid> - 2014-07-02 16:57 +1000
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 10:20 +0000
      Re: Accessing Access database files Robert Klemme <shortcutter@googlemail.com> - 2014-07-02 20:22 +0200
  Re: Accessing Access database files Roedy Green <see_website@mindprod.com.invalid> - 2014-07-02 09:40 -0700
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 21:28 +0000
      Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:09 -0400
  Re: Accessing Access database files Jeff Higgins <jeff@invalid.invalid> - 2014-07-02 17:08 -0400
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 22:39 +0000
  Re: Accessing Access database files Roedy Green <see_website@mindprod.com.invalid> - 2014-07-05 16:28 -0700
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 08:51 +0000
      Re: Accessing Access database files Gordon Levi <gordon@address.invalid> - 2014-07-06 19:01 +1000
        Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 17:11 +0000
          Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 15:17 -0400
            Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 19:30 +0000
              Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 19:10 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 11:26 +0000
          Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 15:27 -0400
            Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 22:37 +0000
              Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 19:06 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 11:45 +0000
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-07 17:50 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 22:34 +0000
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-07 19:24 -0400
    Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 11:55 -0400

csiph-web