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
Nov 13 '05
57  3713 
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]" <PS************ @Timesoft.ch> wrote in message
news:2i******** ****@uni-berlin.de... 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
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]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com... 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]" <PS************ @Timesoft.ch> wrote in message
news:2i******** ****@uni-berlin.de... 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
"paii, Ron" <pa**@packairin c.com> wrote... 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.
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?
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?
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.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com... 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]" <PS************ @Timesoft.ch> wrote in
message news:2i******** ****@uni-berlin.de... 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
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]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com... "paii, Ron" <pa**@packairin c.com> wrote... 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.
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?
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?
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.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com... 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]" <PS************ @Timesoft.ch> wrote in
message news:2i******** ****@uni-berlin.de...
> 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
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]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com... "paii, Ron" <pa**@packairin c.com> wrote... 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.
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?
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?
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.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com... 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]" <PS************ @Timesoft.ch> wrote in
message news:2i******** ****@uni-berlin.de...
> 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
I use compact to copy the front-end to the local computer. It is faster then
using copy on a large front-end.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com... "paii, Ron" <pa**@packairin c.com> wrote... 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.
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?
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?
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.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com... 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]" <PS************ @Timesoft.ch> wrote in
message news:2i******** ****@uni-berlin.de...
> 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
Even faster is using a server that you can run the compact on, directly --
impossible on both Netware and Linux but better performance and reliability
for all.
--
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.
"paii, Ron" <pa**@packairin c.com> wrote in message
news:10******** *****@corp.supe rnews.com... 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]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com... "paii, Ron" <pa**@packairin c.com> wrote... 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.
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?
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?
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.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com...
> 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]" <PS************ @Timesoft.ch> wrote in
message > news:2i******** ****@uni-berlin.de...
> > 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
>
>
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> schrieb im
Newsbeitrag news:40******** @news.microsoft .com... Even faster is using a server that you can run the compact on,
directly --
As long as you have instaled Access on the Server (who does this?-;) and
you have access to that server-;)
impossible on both Netware and Linux but better performance and
reliability
Depends on the app. Once a month in my case. And no repairs of the DB
since 2 Years now...
Peter
"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 reliability
for 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
"Peter Steimann[MVP Access]" <PS************ @Timesoft.ch> wrote... As long as you have instaled Access on the Server (who does this?-;) and
you have access to that server-;)
Um, huh? Jet is there automatically.. .. no one needs Access. impossible on both Netware and Linux but better performance and
reliability
Depends on the app. Once a month in my case. And no repairs of the DB
since 2 Years now...
Again, better perf and better reliability (plus the ability to know that the
scenario is supported) plus no locking worries. All for not doing any of the
pseudo-recommendations for Linux or Novell in this thread.
SO... are these things possible? Of course. If you must do them, will your
app probably live? Yes.
But if you have a choice are they really the best possible options? No, they
are not. And it is amazing that anyone (especially an MVP) would truly
recommend they are the best option on the strength of knowing they are
possible at all.
--
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jhuola Hoptire |
last post by:
Just installed J2RE 1.4.2 on a Linux server. I am very
knew to the POSIX world.
I couldn't dig-up much in the docs or via google about
the following:
1 - Is there a standard way to make sure users (all, or
some) can "reach" java? eg one could presumably create
a java.sh or aliases ... Where is the standard Linux
directory to put such a script (and why)?
|
by: Eric Raymond |
last post by:
When installing the rpms (or the tar file) onto Red Hat Enteprise
Linux AS Beta 1 (Taroon), we get the follwing error:
Installing all prepared tables
/usr/bin/mysql_install_db: line 1: 7690 Segmentation fault
/usr/sbin/mysqld --bootstrap --skip-grant-tables --basedir=/
--datadir=/var/lib/mysql --skip-innodb --skip-bdb
Installation of grant tables failed
The log file simply shows a start and a stop of the server.
|
by: gnu |
last post by:
Rationale to use Linux
=======================
- I can't afford paying for $199 for the license of an OS that's
arguably better thank Linux for each of 10 computers I have.
- I want to be free of Microsoft stigma, and of constant lockdown on
Microsoft products. The world is better than that.
- Linux runs .NET :-) Reverse engineers in less than a year. That's
|
by: Travis 'Bailo' Bickel |
last post by:
Lately, I have been having a bear of a time trying to acquire a Linux driver
for my S3/ProSavage chipset -- but that quest is now almost at an end as I
have located a noble band of people who are pushing the envelop with S3 and
Savage chipset drivers!
Though my quest might sound like food for trolls to mock Linux -- hear me
out. I think I have discovered part of the message of the new Linux
economy. Many of us have criticized the...
|
by: srihari |
last post by:
Hai,
I am trying to install IBM DB2 8.1 on Red Hat linux 8.0. My
machine is Intel XEON 64bit. The installation went well except for the
creation of tools catalog. When I tried to install the tools catalog
as a post installation task I get some java error.
$ db2 CREATE TOOLS CATALOG SYSTOOLS USE EXISTING
DATABASE TOOLSDB FORCE SQL22209N The DB2 Administration Server
encountered an unexpected Java error on host "".
I have jdk1.3 already...
| | |
by: Zorba.GR |
last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
|
by: cranium.2003 |
last post by:
hi,
Here is my code
#include <iostream.h>
int main()
{
cout <<"HI";
return 0;
}
and using following command to compile a C++ program
g++ ex1.cpp -o ex1
|
by: rada.lambretha |
last post by:
Configuring Linux as a Firewall
* Making installation choices
* Introducing iptables
* Using iptables commands
* Simplifying things with firewall GUIs
* Adding proxy functionality
As Linux gains increasing acceptance in corporate datacenters and
|
by: Nepomuk |
last post by:
You might have heard about Linux, but you don't know what it is? Or you know a few things about it, but they terrify you? Well, then this article is for you. Don't be afraid - Everyone can use Linux!
Part 1: What is Linux and why should I use it?
Linux is an Operating System (short: OS). OK, so what is an OS? Let me explain:
Nearly everybody knows Windows. But what exactly does it actually do?
Windows is an example for a OS and one of it's...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
