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

But who has Jet on Win2000 or Server 2003? Everyone.
--
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.
"Tony Toews" <tt****@teluspl anet.net> wrote in message
news:tb******** *************** *********@4ax.c om...

"Michael \(michka\) Kaplan [MS]" <mi*****@online .microsoft.com> wrote:

Even faster is using a server that you can run the compact on, directly --impossible on both Netware and Linux but better performance and reliabilityfor all.

But who installs Access on a server? Very few people.

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

[Tony Toews]

"Michael \(michka\) Kaplan [MS]" <mi*****@online .microsoft.com> wrote:

But who has Jet on Win2000 or Server 2003? Everyone.

Oh, I see. You mean have a VB, C++ or other program automatically run on the server
after midnight using the Jet compacting code.

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

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

"Tony Toews" <tt****@teluspl anet.net> wrote...

Oh, I see. You mean have a VB, C++ or other program automatically run on the server after midnight using the Jet compacting code.

More or less, yes. :-)
--
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.

[Tony Toews]

ja******@oaklan d.edu (James Fortune) wrote:

I have been running samba 3.0.1 as a backend for Access 97 for about
five weeks. The only comments I have heard so far is that the system
is running a little faster than before.
What was it running before? I ask because I'd like to know what versions work well.
I use the line 'veto oplock
files = /*.mdb/*.MDB' in the smb.conf file.
Was this set on general principles or because you were having problems.
The system has about 40 simultaneous users.

Nice to hear.

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

[Peter Steimann[MVP Access]]

Michael

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

And how about the compact issue?

When i read you comments, i remember Steve Ballmer at the last Summit,
when he lifted his right hand up to the sky, the right hand down to the
ground. In one hand was Windows, in the other Linux...its compleatly not
important for me which OS he holds in which hand...especial ly in this
issue.

What about the compacting-issue?

It makes no difference where the database is. (Windows, Linux, Novell)

I would never compact a database on the server itself. You tell us jet
is alredy on the Server.But there is no programm installed on a
standard-server-system which allows you to compact a database directly
on the server. The only argument against Novell and Linux is that you
have a chance to install one there.

We are not talking about operating-systems here. Your argument is no
argument to stay away from installing a backend on a non-windows-system.

You're talking about locking-problems on a samba-share: have you ver
tried it? Novell has also no locking-problems, as long as you modify the
standard-parameters from novell (Record-locks, Filelocks)

I'm not an MVP for Windows-Server. I'm working with access in many
different environements, but i see no reason to to pull on a pair of
pink glasses on. If i had to, i would give back my MVP-title
immediately!

There are arguments for Windows-Server against other operating-systems
(and reverse) But that's not the thread here. And it's not Bradley's
question.

Can he install an Access-Backend on a Linux-Box without any problems?
Without any locking-problems? Yes, he can!

Can he compact a database on a linux-box directly, if he whriley wants
to? Yes, he can (Vine and an installed office on the linux-box)

Can he repair and compact a backend on a linux-box without having Vine?
Yes he can copy the backend to a workstation with an installed Office
and do the job there.

So let's stay realistic, not fanatic.

Peter

[Dimitri Furman]

On Jun 10 2004, 05:26 pm, "Peter Steimann[MVP Access]"
<PS************ @Timesoft.ch> wrote in news:2i******** ****@uni-berlin.de:

You tell us jet
is alredy on the Server.But there is no programm installed on a
standard-server-system which allows you to compact a database directly
on the server.

Just FWIW, VBScript should be quite sufficient.

--
remove a 9 to reply by email

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

"Peter Steimann[MVP Access]" <PS************ @Timesoft.ch> wrote...

What about the compacting-issue?

It makes no difference where the database is. (Windows, Linux, Novell)
Actually, that is not true. It matters a lot. Novell's locking techniques
used to allow you to abend the server if you performed complex Jet
operations (including compact). And on any platform it takes longer to
perform the operation if you do not perform it on the local machine.
I would never compact a database on the server itself.
Well, that is your choice. There are countless throngs that see no problem
with doing this.
You tell us jet is alredy on the Server.But there is no programm installed on a standard-server-system which allows you to compact a database directly
on the server.
And the ones that MS provides, and the ones I provide. Lots of little
utilities that do important things.
The only argument against Novell and Linux is that you
have a chance to install one there.
Pretty huge argument for large databases. And the locking issue on Novell is
still an issue (they fixed the crash but the architecural issue is still
there).
We are not talking about operating-systems here. Your argument is no
argument to stay away from installing a backend on a non-windows-system.
Actually, it is entirely valid, and compact is only one of the issues.
You're talking about locking-problems on a samba-share: have you ver
tried it? Novell has also no locking-problems, as long as you modify the
standard-parameters from novell (Record-locks, Filelocks)
Um, so unless you raise the roof on the number of locks, things can fail.
But think about what that number means, and what you are tying up in the way
of resources on that Novell box. I do understand about this issue from
Novell experts enough to know that the standard "increase the locks" answer
is not always the healthy one for the server.
I'm not an MVP for Windows-Server. I'm working with access in many
different environements, but i see no reason to to pull on a pair of
pink glasses on. If i had to, i would give back my MVP-title
immediately!
I'm not doing a commercial for the flipping product. But I have a production
database that customers rely on, I will choose a platform that has gone
though the extensive tests that the Jet team does for performance, stress,
regressions, and overall stability. Not one that is untested and therefore
unsupported. Just plain common sense...
There are arguments for Windows-Server against other operating-systems
(and reverse) But that's not the thread here. And it's not Bradley's
question.
Good advice does need to color a good answer, though.
Can he install an Access-Backend on a Linux-Box without any problems?
Without any locking-problems? Yes, he can!
Maybe. Its not supported by MS. Is Samba liable if there is some bug in
their implementation that trashes your database?
Can he compact a database on a linux-box directly, if he whriley wants
to? Yes, he can (Vine and an installed office on the linux-box)
Actually, remote compacting is not great on any platform, and emulation is
not too much better (I would not trust it here).
Can he repair and compact a backend on a linux-box without having Vine?
Yes he can copy the backend to a workstation with an installed Office
and do the job there.
Yes, but that takes longer. Without a proven benefit, whats the purpose of
doing all this work?
So let's stay realistic, not fanatic.

Dude, I am being reaslistic, and trying to recommend supported platforms and
techniques that will minimize risk. The fanatics are the ones who are trying
to do stuff just because they can, even when there are good architectural or
support-based reasons to not do them.
--
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]]

Hi Tony

"Tony Toews" <tt****@teluspl anet.net> schrieb im Newsbeitrag
news:1l******** *************** *********@4ax.c om...

ja******@oaklan d.edu (James Fortune) wrote:

I have been running samba 3.0.1 as a backend for Access 97 for about
five weeks. The only comments I have heard so far is that the system
is running a little faster than before.

What was it running before? I ask because I'd like to know what
versions work well.

I started with Samba 2.2.2 and had no locking-problems. The Client runs
2.2.7 for about 1 Year now. I did not test with the latest Version 3.0

I use the line 'veto oplock
files = /*.mdb/*.MDB' in the smb.conf file.

Would be intersting to know! I didn't had to modify the samba.cnf-file

Peter

[David W. Fenton]

"Michael \(michka\) Kaplan [MS]" <mi*****@online .microsoft.com>
wrote in news:40******** @news.microsoft .com:

Is Samba liable if there is some bug in
their implementation that trashes your database?

Is Microsoft?

I don't think so!

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

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

Well, when MS supports the platform and its due to a bug, there is no charge
for the support no matter where it is escalated to, and that includes if
they end up doing hot fixes and such.

I have (on behalf of customers) been able to take advantage of that policy,
and have found the notion of what is supported to be a very comfortable
place upon which to sit.
--
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.
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** **********@24.1 68.128.86...

"Michael \(michka\) Kaplan [MS]" <mi*****@online .microsoft.com>
wrote in news:40******** @news.microsoft .com:

Is Samba liable if there is some bug in
their implementation that trashes your database?

Is Microsoft?

I don't think so!

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc