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

Re: Accessing Access database files

Date	2014-07-07 17:50 -0400
From	Arne Vajhøj <arne@vajhoej.dk>
Newsgroups	comp.lang.java.programmer
Subject	Re: Accessing Access database files
References	(4 earlier) <lpbvvc$ivp$2@dont-email.me> <53b9a333$0$303$14726298@news.sunsite.dk> <lpcj3t$26o$1@dont-email.me> <53b9d677$0$295$14726298@news.sunsite.dk> <lpe18k$jqe$2@dont-email.me>
Message-ID	<53bb161b$0$293$14726298@news.sunsite.dk> (permalink)
Organization	SunSITE.dk - Supporting Open source

Show all headers | View raw

On 7/7/2014 7:45 AM, Martin Gregorie wrote:
> On Sun, 06 Jul 2014 19:06:30 -0400, Arne Vajhøj wrote:
>> On 7/6/2014 6:37 PM, Martin Gregorie wrote:
>>> On Sun, 06 Jul 2014 15:27:47 -0400, Arne Vajhøj wrote:
>>>> SQLServer CE is an embedded database that are not very widely known,
>>>> but it is actually quite nice. If I had to use an embedded database in
>>>> .NET environment, then it would be my pick too.
>>>>
>>> Maybe SQL Server Compact is SQL Server CE recompiled to run on Windows
>>> Server boxes?
>>
>> SQLServer Compact is often abbreviated SQLServer CE.
>>
>> I think:
>>     CE = Compact Edition.
>>
>> http://en.wikipedia.org/wiki/SQL_Server_Compact
>>
> Thanks for that: it clarifies things a lot.

> So, it looks as though SQL Server Compact is intended to be pretty much a
> drop-in replacement[*] for Access,

It is.

>                                   particularly for systems that use ODBC
> or JDBC as their DBMS interface.

Not so.

SQLServer CE does not come with ODBC or JDBC at all.

It only comes with OLE DB (ADO) and ADO.NET providers.

>                              I'd wondered, too, if it might suffer
> from the general MS filesize limitation of 4GB. It does.

The general MS file size limitation is 16 TB for older Windows
and 256 TB for newer Windows.

(well it was 2/4 GB if we go back to Win9x in the 1990's)

But yes - SQLServer CE is limited to 4 GB.

I don't think it is that bad. If you need more space, then you
should probably go SQLServer anyway.

Arne

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