Networking

[Guest]

I have a Data Base on the main server and linked data bases on two remote
machines. They all have passwords to open them. They were working fine, but
all of a sudden, when a user accesses the Forms, they cannot enter or change
any information. I have relinked to no avail and checked that they are not
read only.
Could anyone please tell me what the problem could be? Could it be the
actual networking itself. It is a wireless network.

 

[Guest]

Hi Roger,

Linking an Access database across a wireless network is asking for trouble,
but probably not the cause of your problem.

The problem you have described sounds more like the users don't have full
read/write permissions to the new directory that you moved your backend to.

Hope this helps.

Damian.

 

[Guest]

Thanks for that Damian.
Can you enlighten me as to potential problems when linking an Acess data
base across a wireless network? The main problem is with a Laptop (Wireless)

I have checked under Tools, Security, User and Group permissions and full
rights have been allocated. Could it be anything to do with the system.mdw
file?

Thanks again

 

[Guest]

Albert Kallal's article at
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html explains the whys and
wherefores.

John Nurick
Microsoft Access MVP

 

[Albert D. Kallal]

If you removed create rights to that directory, then often ms-access can't
crate a temp file in that directory for multi-user access. If that temp file
can't be created, then ms-access defaults to single user mode, or read only
mode.....


So, while the user might have read/write access to the directory, they might
not have create rights (or that was taken away).

Sounds strange, but the result of taking away create rights from that back
end directory results in a read only application!!

 

[Guest]

Thanks for the insight Albert. As I am no expert, where would one go to
check if Create Rights have been removed. The Data Base is located on the
Server with standard security within the System.mdw file and the Laptop has a
copy with the tables linked to the server data base. It has worked on
previous networks without a problem, and just seems to be a problem in this
specific case. Obviously the Network is connecting to the server file, and
the data base can be viewed, but cannot be changed. I have not encountered
this on previous installations. Sorrry to be a pain!

 

[Albert D. Kallal]

Thanks for the insight Albert. As I am no expert, where would one go to
check if Create Rights have been removed. The Data Base is located on the
Server with standard security within the System.mdw file and the Laptop
has a
copy with the tables linked to the server data base. It has worked on
previous networks without a problem, and just seems to be a problem in
this
specific case. Obviously the Network is connecting to the server file,
and
the data base can be viewed, but cannot be changed. I have not
encountered
this on previous installations. Sorrry to be a pain!

This is not a ms-access setting. If you can right click, and create a text
file in he dir..and save it..then you have create rights...

It would be the file permissions that you set on the server for that user.

And, perhaps you copied the files off of a cd rom (cd rom = Read Only
Memory).

You might just want to right click on the mdb back end file, and make sure
the "read only" setting is not checked (it will be if you copied the file
from a cd...).

So, just try creating a text file in that dir...if you can create that text
file, and save it..then that computer has create rights...

I would right click on the mdb file...and ensure the read only is
un-checked....