"Read Only" error blocks linked tables

G

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
 
M

mcescher

How was the FE distributed? If it went out via CD, that db will be
read only until they move it over to the hard drive or network drive.
If it sits on a network drive, do the users have read/write rights to
the directory structure? Can the user create a text file in the
directory that holds the database?

HTH,
Chris
 
G

Guest

Thanks for the reply ...

It is distributed via web download in a zip file. The user saves to his/her
computer and unzips the file on their own computer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top