Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: Access Application on Apache

0 views
Skip to first unread message

Douglas J. Steele

unread,
Dec 11, 2006, 4:38:21 PM12/11/06
to
No, "Access Application" doesn't imply a web form communicating with an
Access database.

I'm not sure Access will run on a Linux server: it needs Windows, and I'm
not sure WINE is good enough.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"jDmiller" <jDmi...@discussions.microsoft.com> wrote in message
news:45A6BF0C-E872-40DC...@microsoft.com...
> Can you run an Access Application on a Linux server running Apache? It has
> MySQL on it. "Access Application" implies a web form communicating with an
> Access database right? So I guess I'm asking if you can install Access on
> my
> system and if it will run side by side with MySQL?


David W. Fenton

unread,
Dec 11, 2006, 8:53:10 PM12/11/06
to
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
news:OnE9uyWH...@TK2MSFTNGP02.phx.gbl:

> I'm not sure Access will run on a Linux server: it needs Windows,
> and I'm not sure WINE is good enough.

I would never store a Jet MDB on anything other than a genuine
Windows file system. It's too fragile as it is to introduce yet
another point of possible incompatibility.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

aaron...@gmail.com

unread,
Dec 11, 2006, 11:52:54 PM12/11/06
to
I strongly applaud your skepticism on MDB stability; you know-- if we
all pushed MS to focus on their strengths-- instead of horse around
with YET ANOTHER NEW FORMAT then maybe we could use our resources to
help convince Microsoft to save the Access family.

As it is; since you guys sit there and blindly defend MDB against ADP
then you fight for the wrong side.

The ADP movement could use a strong person David.

-Aaron
ADP Nationalist

James A. Fortune

unread,
Dec 13, 2006, 6:35:51 PM12/13/06
to
David W. Fenton wrote:
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
> news:OnE9uyWH...@TK2MSFTNGP02.phx.gbl:
>
>
>>I'm not sure Access will run on a Linux server: it needs Windows,
>>and I'm not sure WINE is good enough.
>
>
> I would never store a Jet MDB on anything other than a genuine
> Windows file system. It's too fragile as it is to introduce yet
> another point of possible incompatibility.
>

I agree with Douglas that WINE doesn't seem reliable enough, but I
haven't tried that. I agree with David that the mdb is fragile,
especially on a genuine Windows file system :-). I have stored backend
mdb's on Linux using Samba and found it to be the most stable and
reliable combination I've ever encountered for using Access over a LAN.
Data access is really fast too. In fact, I think the speed accounts
for much of the improved reliability (edits took about one fourth the
time in my case). On the flip side, if you run into problems with that
setup, you're pretty much on your own.

James A. Fortune
MPAP...@FortuneJames.com

aaron...@gmail.com

unread,
Dec 13, 2006, 7:11:42 PM12/13/06
to
holy crap are you kidding me?

I'd love to look into this; does linux support good compression ratios?
simlar to NTFS compression.. but on the samba side?

that would be a killer combo; might make MS world competitive with say
DB2 which does a bunch of compression for certain fields.. right?

with winrar; i can get almost 10:1 compression ratio.. but that's going
to vary depending on stuff like normalization I assume

-Aaron

Tony Toews

unread,
Dec 16, 2006, 9:34:08 PM12/16/06
to
"James A. Fortune" <MPAP...@FortuneJames.com> wrote:

> I agree with David that the mdb is fragile,
>especially on a genuine Windows file system :-).

<chuckle>

>I have stored backend
>mdb's on Linux using Samba and found it to be the most stable and
>reliable combination I've ever encountered for using Access over a LAN.
> Data access is really fast too. In fact, I think the speed accounts
>for much of the improved reliability (edits took about one fourth the
>time in my case).

Interesting that. Something to think about. I vaguely recall
reading somewhere that Novell Network was significantly faster in raw
file server throughput than Windows 2000 Server. But MS got Win 2003
Server running faster than Win 2000 Server but not quite to Netware.

> On the flip side, if you run into problems with that
>setup, you're pretty much on your own.

True enough.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

0 new messages