Linux

**Michael \(michka\) Kaplan [MS]** · Nov 13 '05, 12:19 AM

Re: Linux

The problem is that the file locking mechanism used by Jet is not available
on the Linux box -- so no multiuser is available.

--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"B.r.a.d.l. e.y" <bradley@comcen .REMOVETHIScom. au> wrote in message
news:40c2ff27$1 _2@news.melbour ne.pipenetworks .com...[color=blue]
> A client has moved a back-end data file to a Linux machine instead of
> Windows. It now will only let one user log in at a time and gives some
> sort of "admin file not found" error.
>
> My first thought was permissions to create the LDB file but they swear
> this is correct.
> (read/write access for MDB & MDW files, read/write/create access in
> folder)
>
> Anyone come across a similar problem?
> --
> regards,
>
> Bradley
>
>[/color]

**Randy Harris** · Nov 13 '05, 12:19 AM

Re: Linux

"Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> wrote in
message news:40c32798@n ews.microsoft.c om...[color=blue]
> The problem is that the file locking mechanism used by Jet is not[/color]
available

MichKa, where can I find documentation on the Jet file locking? I sure
would like to learn more about how that works.

Randy Harris
[color=blue]
> on the Linux box -- so no multiuser is available.[/color]
[color=blue]
>
> --
> MichKa [MS]
> NLS Collation/Locale/Keyboard Development
> Globalization Infrastructure and Font Technologies[/color]

**Michael \(michka\) Kaplan [MS]** · Nov 13 '05, 12:20 AM

Re: Linux

See the Kevin Collins article "Understand ing Micosoft Jet Locking":

http://www.microsoft.com/accessdev/articles/jetlock.htm

Kevin definitely knows more about Jet and SQL Server (Windows CE edition)
locking than almost anyone else on the planet....

He is as long time MS employee (currently a Senior Program Manager) who just
recently celbrated his 10th year at MS. Back when he used to regularly speak
at Advisor conferences, he would constantly leak secret information about
Jet that he was probably not supposed to, the point where they started
making all of his talks covered by non-disclosure agreements to keep people
from blabbing later on.

Even though he was not always the most engaging speaker from a personality
standpoint, he routinely got high ratings and everyone was on the edge of
their seats hoping for the next bit of revealing information.... I have
always been a huge fan of his talks and tried to model that "talking to
colleagues about cool stuff they want to know" style because I figured it
would protect me from boring people if I ever slipped into that sort of
thing. :-)

--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Randy Harris" <randy@SpamFree .com> wrote in message
news:ySHwc.2045 1$eH1.9201169@n ewssvr28.news.p rodigy.com...[color=blue]
>
> "Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> wrote in
> message news:40c32798@n ews.microsoft.c om...[color=green]
> > The problem is that the file locking mechanism used by Jet is not[/color]
> available
>
> MichKa, where can I find documentation on the Jet file locking? I sure
> would like to learn more about how that works.
>
> Randy Harris
>[color=green]
> > on the Linux box -- so no multiuser is available.[/color]
>[color=green]
> >
> > --
> > MichKa [MS]
> > NLS Collation/Locale/Keyboard Development
> > Globalization Infrastructure and Font Technologies[/color]
>
>[/color]

**Peter Steimann[MVP Access]** · Nov 13 '05, 12:20 AM

Re: Linux

"B.r.a.d.l. e.y" <bradley@comcen .REMOVETHIScom. au> schrieb im Newsbeitrag
news:40c2ff27$1 _2@news.melbour ne.pipenetworks .com...[color=blue]
>A client has moved a back-end data file to a Linux machine instead of
> Windows. It now will only let one user log in at a time and gives some
> sort of "admin file not found" error.
>
> My first thought was permissions to create the LDB file but they swear
> this is correct.
> (read/write access for MDB & MDW files, read/write/create access in
> folder)[/color]

It works as follows:

-Use Samba >2.2.7 and copy the backend to this share
-Read/write-permisssion for the users
-Install the frontend on every pc an connect the tables
-Read the doc readme2k.txt in the samba-share of the linux-box

Peter

**Tony Toews** · Nov 13 '05, 12:20 AM

Re: Linux

"B.r.a.d.l. e.y" <bradley@comcen .REMOVETHIScom. au> wrote:
[color=blue]
>A client has moved a back-end data file to a Linux machine instead of
>Windows. It now will only let one user log in at a time and gives some
>sort of "admin file not found" error.
>
>My first thought was permissions to create the LDB file but they swear
>this is correct.
>(read/write access for MDB & MDW files, read/write/create access in
>folder)[/color]

I know nothing about Linux/Samba but is there also delete rights you can set?

As a followup to Peter's comment what version of Samba do you have installed?

Please post back what worked and what didn't so we'll all know for the future.

Thanks, 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

Tony's Main Microsoft Access Page

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Hint's, Tips and FAQ

**Steve Jorgensen** · Nov 13 '05, 12:20 AM

Re: Linux

I had been lead to believe that the newer SAMBA 2.0 emulates all the necessary
Windows networking features to allow successful sharing of Access files. I
haven't tried it myself, though.

On Sun, 6 Jun 2004 07:17:25 -0700, "Michael $michka$ Kaplan [MS]"
<michkap@online .microsoft.com> wrote:
[color=blue]
>The problem is that the file locking mechanism used by Jet is not available
>on the Linux box -- so no multiuser is available.[/color]

**Michael \(michka\) Kaplan [MS]** · Nov 13 '05, 12:20 AM

Re: Linux

Hmmm.... interesting. Now all one needs is a scenario where it makes sense
to use it? :-)

--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
news:qor6c09b2s 6gmqetaeedcmcj2 te4rltrjl@4ax.c om...[color=blue]
> I had been lead to believe that the newer SAMBA 2.0 emulates all the[/color]
necessary[color=blue]
> Windows networking features to allow successful sharing of Access files.[/color]
I[color=blue]
> haven't tried it myself, though.
>
> On Sun, 6 Jun 2004 07:17:25 -0700, "Michael $michka$ Kaplan [MS]"
> <michkap@online .microsoft.com> wrote:
>[color=green]
> >The problem is that the file locking mechanism used by Jet is not[/color][/color]
available[color=blue][color=green]
> >on the Linux box -- so no multiuser is available.[/color]
>[/color]

**bradley.** · Nov 13 '05, 12:20 AM

Re: Linux

Tony Toews wrote:[color=blue]
> "B.r.a.d.l. e.y" <bradley@comcen .REMOVETHIScom. au> wrote:
>[color=green]
>> A client has moved a back-end data file to a Linux machine instead of
>> Windows. It now will only let one user log in at a time and gives
>> some sort of "admin file not found" error.
>>
>> My first thought was permissions to create the LDB file but they
>> swear this is correct.
>> (read/write access for MDB & MDW files, read/write/create access in
>> folder)[/color]
>
> I know nothing about Linux/Samba but is there also delete rights you
> can set?
>
> As a followup to Peter's comment what version of Samba do you have
> installed?
>
> Please post back what worked and what didn't so we'll all know for
> the future.
>
> Thanks, Tony[/color]

Unfortuantely I haven't even seen the Linux machine or know anything
about it... but I will endeavor to finf out!!
--
regards,

Bradley

**Peter Steimann[MVP Access]** · Nov 13 '05, 12:21 AM

Re: Linux

Hi Michael

"Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> schrieb im
Newsbeitrag news:40c35955$1 @news.microsoft .com...[color=blue]
> See the Kevin Collins article "Understand ing Micosoft Jet Locking":
>[/color]

I do not know so much as Kevin does, for shure-;) but:

I do have an Installation running on Access 97 and Suse 8.1 (Samba
2.2.7) and i do not have any locking problems in this
multiuser-environement (5 User). Whatever...it works in my case...

Peter

**Michael \(michka\) Kaplan [MS]** · Nov 13 '05, 12:21 AM

Re: Linux

As far as I know, Kevin does not mention Linux in the white paper, but I am
almost certian that the scenario is untested by the Jet team and therefore
unsupported .

Others have claimed that a late enough Samba version allows the scenario to
work. Now all one needs is (a) a good reason to bother and (b) faith that
they will never run into problems.

Given the fact that the backend should be compacted regularly and compacts
over a network are never advised, this seems like a bad idea in any case
(including the original scenario).

--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Peter Steimann[MVP Access]" <PSteimann.News @Timesoft.ch> wrote in message
news:2ijosbFnsq kkU2@uni-berlin.de...[color=blue]
> Hi Michael
>
> "Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> schrieb im
> Newsbeitrag news:40c35955$1 @news.microsoft .com...[color=green]
> > See the Kevin Collins article "Understand ing Micosoft Jet Locking":
> >[/color]
>
> I do not know so much as Kevin does, for shure-;) but:
>
> I do have an Installation running on Access 97 and Suse 8.1 (Samba
> 2.2.7) and i do not have any locking problems in this
> multiuser-environement (5 User). Whatever...it works in my case...
>
> Peter[/color]

**paii, Ron** · Nov 13 '05, 12:21 AM

Re: Linux

I have had a large Access 97 back-end on a Novell server for years and
rarely had problems compacting over the network. ALWAYS HAVE A BACKUP.

As for Samba and Linux, there was a long discussion last year in this group,
that did not recommended this combination. Has this changed with Samba 3x?

"Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> wrote in
message news:40c4b210$1 @news.microsoft .com...[color=blue]
> As far as I know, Kevin does not mention Linux in the white paper, but I[/color]
am[color=blue]
> almost certian that the scenario is untested by the Jet team and therefore
> unsupported .
>
> Others have claimed that a late enough Samba version allows the scenario[/color]
to[color=blue]
> work. Now all one needs is (a) a good reason to bother and (b) faith that
> they will never run into problems.
>
> Given the fact that the backend should be compacted regularly and compacts
> over a network are never advised, this seems like a bad idea in any case
> (including the original scenario).
>
>
> --
> MichKa [MS]
> NLS Collation/Locale/Keyboard Development
> Globalization Infrastructure and Font Technologies
>
> This posting is provided "AS IS" with
> no warranties, and confers no rights.
>
>
> "Peter Steimann[MVP Access]" <PSteimann.News @Timesoft.ch> wrote in message
> news:2ijosbFnsq kkU2@uni-berlin.de...[color=green]
> > Hi Michael
> >
> > "Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> schrieb im
> > Newsbeitrag news:40c35955$1 @news.microsoft .com...[color=darkred]
> > > See the Kevin Collins article "Understand ing Micosoft Jet Locking":
> > >[/color]
> >
> > I do not know so much as Kevin does, for shure-;) but:
> >
> > I do have an Installation running on Access 97 and Suse 8.1 (Samba
> > 2.2.7) and i do not have any locking problems in this
> > multiuser-environement (5 User). Whatever...it works in my case...
> >
> > Peter[/color]
>
>[/color]

**Michael \(michka\) Kaplan [MS]** · Nov 13 '05, 12:21 AM

Re: Linux

"paii, Ron" <paii@packairin c.com> wrote...[color=blue]
> I have had a large Access 97 back-end on a Novell server for years and
> rarely had problems compacting over the network. ALWAYS HAVE A BACKUP.[/color]

The word rarely of course should bring up the caution flag. Have you ever
timed the difference between a network compact and a local one?
[color=blue]
> As for Samba and Linux, there was a long discussion last year in this[/color]
group,[color=blue]
> that did not recommended this combination. Has this changed with Samba 3x?[/color]

Not sure. But it seems odd to be so anxious to push the evelope this way....

--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

[color=blue]
>
> "Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> wrote in
> message news:40c4b210$1 @news.microsoft .com...[color=green]
> > As far as I know, Kevin does not mention Linux in the white paper, but I[/color]
> am[color=green]
> > almost certian that the scenario is untested by the Jet team and[/color][/color]
therefore[color=blue][color=green]
> > unsupported .
> >
> > Others have claimed that a late enough Samba version allows the scenario[/color]
> to[color=green]
> > work. Now all one needs is (a) a good reason to bother and (b) faith[/color][/color]
that[color=blue][color=green]
> > they will never run into problems.
> >
> > Given the fact that the backend should be compacted regularly and[/color][/color]
compacts[color=blue][color=green]
> > over a network are never advised, this seems like a bad idea in any case
> > (including the original scenario).
> >
> >
> > --
> > MichKa [MS]
> > NLS Collation/Locale/Keyboard Development
> > Globalization Infrastructure and Font Technologies
> >
> > This posting is provided "AS IS" with
> > no warranties, and confers no rights.
> >
> >
> > "Peter Steimann[MVP Access]" <PSteimann.News @Timesoft.ch> wrote in[/color][/color]
message[color=blue][color=green]
> > news:2ijosbFnsq kkU2@uni-berlin.de...[color=darkred]
> > > Hi Michael
> > >
> > > "Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> schrieb[/color][/color][/color]
im[color=blue][color=green][color=darkred]
> > > Newsbeitrag news:40c35955$1 @news.microsoft .com...
> > > > See the Kevin Collins article "Understand ing Micosoft Jet Locking":
> > > >
> > >
> > > I do not know so much as Kevin does, for shure-;) but:
> > >
> > > I do have an Installation running on Access 97 and Suse 8.1 (Samba
> > > 2.2.7) and i do not have any locking problems in this
> > > multiuser-environement (5 User). Whatever...it works in my case...
> > >
> > > Peter[/color]
> >
> >[/color]
>
>[/color]

**Larry Linson** · Nov 13 '05, 12:21 AM

Re: Linux

At one time I had an "officially multiuser" backend on a Unix (HP-UX)
server. But it was a small DB and was used by a very small group of people
to record project information. I am relatively sure there never was more
than a one user at any given time, so though it was "officially multiuser",
practically speaking, it was "single user". I never had any problem with it.
Nothing was ever deleted, so bloat wasn't a problem, and I don't recall ever
compacting it.

JIC, though, I periodically made a backup copy to my own hard drive.

Larry Linson
Microsoft Access MVP

"Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> wrote in
message news:40c4b890$1 @news.microsoft .com...[color=blue]
> "paii, Ron" <paii@packairin c.com> wrote...[color=green]
> > I have had a large Access 97 back-end on a Novell server for years and
> > rarely had problems compacting over the network. ALWAYS HAVE A BACKUP.[/color]
>
> The word rarely of course should bring up the caution flag. Have you ever
> timed the difference between a network compact and a local one?
>[color=green]
> > As for Samba and Linux, there was a long discussion last year in this[/color]
> group,[color=green]
> > that did not recommended this combination. Has this changed with Samba[/color][/color]
3x?[color=blue]
>
> Not sure. But it seems odd to be so anxious to push the evelope this[/color]
way....[color=blue]
>
>
> --
> MichKa [MS]
> NLS Collation/Locale/Keyboard Development
> Globalization Infrastructure and Font Technologies
>
> This posting is provided "AS IS" with
> no warranties, and confers no rights.
>
>[color=green]
> >
> > "Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> wrote in
> > message news:40c4b210$1 @news.microsoft .com...[color=darkred]
> > > As far as I know, Kevin does not mention Linux in the white paper, but[/color][/color][/color]
I[color=blue][color=green]
> > am[color=darkred]
> > > almost certian that the scenario is untested by the Jet team and[/color][/color]
> therefore[color=green][color=darkred]
> > > unsupported .
> > >
> > > Others have claimed that a late enough Samba version allows the[/color][/color][/color]
scenario[color=blue][color=green]
> > to[color=darkred]
> > > work. Now all one needs is (a) a good reason to bother and (b) faith[/color][/color]
> that[color=green][color=darkred]
> > > they will never run into problems.
> > >
> > > Given the fact that the backend should be compacted regularly and[/color][/color]
> compacts[color=green][color=darkred]
> > > over a network are never advised, this seems like a bad idea in any[/color][/color][/color]
case[color=blue][color=green][color=darkred]
> > > (including the original scenario).
> > >
> > >
> > > --
> > > MichKa [MS]
> > > NLS Collation/Locale/Keyboard Development
> > > Globalization Infrastructure and Font Technologies
> > >
> > > This posting is provided "AS IS" with
> > > no warranties, and confers no rights.
> > >
> > >
> > > "Peter Steimann[MVP Access]" <PSteimann.News @Timesoft.ch> wrote in[/color][/color]
> message[color=green][color=darkred]
> > > news:2ijosbFnsq kkU2@uni-berlin.de...
> > > > Hi Michael
> > > >
> > > > "Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com>[/color][/color][/color]
schrieb[color=blue]
> im[color=green][color=darkred]
> > > > Newsbeitrag news:40c35955$1 @news.microsoft .com...
> > > > > See the Kevin Collins article "Understand ing Micosoft Jet[/color][/color][/color]
Locking":[color=blue][color=green][color=darkred]
> > > > >
> > > >
> > > > I do not know so much as Kevin does, for shure-;) but:
> > > >
> > > > I do have an Installation running on Access 97 and Suse 8.1 (Samba
> > > > 2.2.7) and i do not have any locking problems in this
> > > > multiuser-environement (5 User). Whatever...it works in my case...
> > > >
> > > > Peter
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

**paii, Ron** · Nov 13 '05, 12:21 AM

Re: Linux

Rarely is 2 or 3 times in 4 years the repair and compact failed. I never
confirmed if it was a network problem, I was able to restore from backup and
compact the database. Yes it is faster to backup locally but then I would
have to move the database to my local disk, compact, then move back to the
Netware volume.

"Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> wrote in
message news:40c4b890$1 @news.microsoft .com...[color=blue]
> "paii, Ron" <paii@packairin c.com> wrote...[color=green]
> > I have had a large Access 97 back-end on a Novell server for years and
> > rarely had problems compacting over the network. ALWAYS HAVE A BACKUP.[/color]
>
> The word rarely of course should bring up the caution flag. Have you ever
> timed the difference between a network compact and a local one?
>[color=green]
> > As for Samba and Linux, there was a long discussion last year in this[/color]
> group,[color=green]
> > that did not recommended this combination. Has this changed with Samba[/color][/color]
3x?[color=blue]
>
> Not sure. But it seems odd to be so anxious to push the evelope this[/color]
way....[color=blue]
>
>
> --
> MichKa [MS]
> NLS Collation/Locale/Keyboard Development
> Globalization Infrastructure and Font Technologies
>
> This posting is provided "AS IS" with
> no warranties, and confers no rights.
>
>[color=green]
> >
> > "Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com> wrote in
> > message news:40c4b210$1 @news.microsoft .com...[color=darkred]
> > > As far as I know, Kevin does not mention Linux in the white paper, but[/color][/color][/color]
I[color=blue][color=green]
> > am[color=darkred]
> > > almost certian that the scenario is untested by the Jet team and[/color][/color]
> therefore[color=green][color=darkred]
> > > unsupported .
> > >
> > > Others have claimed that a late enough Samba version allows the[/color][/color][/color]
scenario[color=blue][color=green]
> > to[color=darkred]
> > > work. Now all one needs is (a) a good reason to bother and (b) faith[/color][/color]
> that[color=green][color=darkred]
> > > they will never run into problems.
> > >
> > > Given the fact that the backend should be compacted regularly and[/color][/color]
> compacts[color=green][color=darkred]
> > > over a network are never advised, this seems like a bad idea in any[/color][/color][/color]
case[color=blue][color=green][color=darkred]
> > > (including the original scenario).
> > >
> > >
> > > --
> > > MichKa [MS]
> > > NLS Collation/Locale/Keyboard Development
> > > Globalization Infrastructure and Font Technologies
> > >
> > > This posting is provided "AS IS" with
> > > no warranties, and confers no rights.
> > >
> > >
> > > "Peter Steimann[MVP Access]" <PSteimann.News @Timesoft.ch> wrote in[/color][/color]
> message[color=green][color=darkred]
> > > news:2ijosbFnsq kkU2@uni-berlin.de...
> > > > Hi Michael
> > > >
> > > > "Michael (michka) Kaplan [MS]" <michkap@online .microsoft.com>[/color][/color][/color]
schrieb[color=blue]
> im[color=green][color=darkred]
> > > > Newsbeitrag news:40c35955$1 @news.microsoft .com...
> > > > > See the Kevin Collins article "Understand ing Micosoft Jet[/color][/color][/color]
Locking":[color=blue][color=green][color=darkred]
> > > > >
> > > >
> > > > I do not know so much as Kevin does, for shure-;) but:
> > > >
> > > > I do have an Installation running on Access 97 and Suse 8.1 (Samba
> > > > 2.2.7) and i do not have any locking problems in this
> > > > multiuser-environement (5 User). Whatever...it works in my case...
> > > >
> > > > Peter
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

Linux

Linux

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment