Read Only locks out some users from linked tables

[Guest]

I have a VBA front-end database used by many soldiers around the world. The
database uses linked tables. Each user has a copy of the back end in the
same folder as the front end.

Some (not all) users get a "read only" message when they open the front end
(VBA database), and because the read only lock it won't update the links the
in database causing it to not function.

None of the files are set to "read only".

The whole package works on all the computers in my local area at work and I
have not been able to recreate the problem there so it has been hard to
trouble shoot.
(Running Office XP with SP2)

Installing a fresh version of MS Office XP with out the service packs at
home did recreate the error. This leads me to think that this problem may be
linked to the version of access being used.

Does anyone have any suggestions on how to solve the problem?

Thanks,
JR

 

[John Nurick]

Hi JR,

Sometimes you can get a "read-only" effect from the folder even though
the .mdb files are not read-only. Read-write use of Access requires the
user to have RWXD (read/write/execute/delete) permission on the folder.
Is it possible that some of these users have limited network permissions
on the folder containing the files?

 

[Guest]

Thanks John,

BUT the file in question is in a zip file that the user downloads to their
computer from the web. Once there the zip file is on their computer, they
unzip it to a folder and run it from there.

One thing I did not mention is that there are TWO Access Databases in the
zip file, one that has the VBA in it, the second has the tables that link to
the first.

Perhaps that is a source of conflict?

But if it is why is the problem not universal? Why does it work on some
computers and not on others? (All my coworkers can run the VBA file on their
computers -- many other users have had success. But not all.)