Linux

[B.r.a.d.l.e.y]

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

[Michael \(michka\) Kaplan [MS]]

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" <br*****@comcen .REMOVETHIScom. au> wrote in message
news:40******** **@news.melbour ne.pipenetworks .com...

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

[Randy Harris]

"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******@n ews.microsoft.c om...

The problem is that the file locking mechanism used by Jet is not 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
on the Linux box -- so no multiuser is available.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

[Michael \(michka\) Kaplan [MS]]

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" <ra***@SpamFree .com> wrote in message
news:yS******** *************@n ewssvr28.news.p rodigy.com...

"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******@n ews.microsoft.c om...

The problem is that the file locking mechanism used by Jet is not

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

on the Linux box -- so no multiuser is available.

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

[Peter Steimann[MVP Access]]

"B.r.a.d.l. e.y" <br*****@comcen .REMOVETHIScom. au> schrieb im Newsbeitrag
news:40******** **@news.melbour ne.pipenetworks .com...

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)

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]

"B.r.a.d.l. e.y" <br*****@comcen .REMOVETHIScom. au> wrote:

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)

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
http://www.granite.ab.ca/accsmstr.htm

[Steve Jorgensen]

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]"
<mi*****@online .microsoft.com> wrote:

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

[Michael \(michka\) Kaplan [MS]]

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" <no****@nospam. nospam> wrote in message
news:qo******** *************** *********@4ax.c om...

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]"
<mi*****@online .microsoft.com> wrote:

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

[bradley.]

Tony Toews wrote:

"B.r.a.d.l. e.y" <br*****@comcen .REMOVETHIScom. au> wrote:

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)

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

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]]

Hi Michael

"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> schrieb im
Newsbeitrag news:40******** @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