Multiuser Access from Linux Server

M

Matt

Our Linux server was recently upgraded. Before the upgrade, we could put our
Access DB on the server and multiple users could access the same DB.

After the access, the first user can get in but subsequent users get a popup
stating that DB can't be found. You can click off the popup and the Access
program remains open but with no DB opened. If you go to drop down menu FILE
- OPEN, you can navigate to the DB and it will open.

Why do I get the rid of the popup error so second and subsequent users can
go directly into the DB???
 
A

Albert D. Kallal

This is likely a permissions problem.

Your users need create, delete rights here. If users are not given full
rights, then the locking files can't be created and deleted for correct
operation of the application. (and, thus single user mode is used).
 
M

Matt

Users do have read and write rights, it seems that the ldb file is not giving
everyone read, write, execute premission.

Would you know why it would change just because we changed OS versions?
 
A

Albert D. Kallal

Matt said:
Users do have read and write rights, it seems that the ldb file is not
giving
everyone read, write, execute premission.
Click to expand...

Your users also need create rights, and also need deletion rights. When I
said full rights...I meant full rights. You might even have a situation
where some users have correct permissions, and some don't (so, depending on
who opens the file first..additional users may, or may not be able to open
the file!). Try testing with a dir that has NO permissions whatsoever..and
see if that works. Remember, each individual users workstation will be
deleting, and creating that lock file. IF the file can't be created, or
deleted, then multi-user operation is effected.
Would you know why it would change just because we changed OS versions?
Click to expand...

Gee, you changed from airplanes to cars? Changing a operating systems is for
sure a rather HUGE HUGE step here. The question in this regards would not be
"why", but in fact "what" or "how much" has changed. Changing a OS is not a
small affair here!!

You might have to check with your vendor etc. as to what has been changed.

So changing a OS certainly might be the cause of your problems, and there
should be ZERO surprises that something changed!! However, I would take that
issue up with your vendor.

My best guess is still permissions is a problem, and I would try and
eliminate that issue first.
 
M

Matt

The strange thing is that I got another DB that doesn't have this problem...
it opens with no issues
 
T

Tony Toews

Matt said:
The strange thing is that I got another DB that doesn't have this problem...
it opens with no issues
Click to expand...

Is it in the same folder as the other DB?

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
 
M

Matt

It doesn't seem to matter which folder I put the DB in... it looks like it
has more to do with something with the DB
 
Top