Ideas on Why an Access database says Read Only

  • Thread starter Thread starter Veign
  • Start date Start date
Thre are a few different things that could be at play here... I'd check with
the "security permissions" settings and also the "share permissions" (they
are, infact 2 different sets of permissions) Make sure they have
Read/Write/Modify/Execute permissions. Also, make sure the user policy
dosn't affect the group policies...

Also, make sure no other users have the database/table open "exclusively"
before you try and import/export. There are lots of different reasons why
it switches to "exclusive" so make sure you check all aspects.

One last thing to check for... is if this is stored on a 2k/xp machine, try
turning off the caching, so changes are written immediately.

one other thing that might be affecting this...
make sure the users also have rights to the "system.mdw" on their local
machines. I've seen some weird results from this...


I hope this helps
:)
 
Veign said:
Any ideas why an Access database when performing an Import or Export
says that it "Database or Object is Read Only". This primarily occur
on WinXP / WinNT machines. Database is located on a server and users
do have proper rights to the file / directory

Depending on what you're trying to import from or export to and what
service pack of Jet is installed, you may get this message when you try
to work with text files that have extensions that aren't on the approved
list:

txt
csv
tab
asc
htm
html

This KB article explains it:

http://support.microsoft.com/default.aspx?scid=kb;en-us;245407

The article also gives you two workarounds:

(1) modify the registry settings to add an extension to the list, or

(2) If you're importing, rename the file to change the extension
(you can use the Name statement to do this), or copy it before importing
to a name with an approved extension (you can use the FileCopy statement
to do this). Then import the renamed or copied file. If necessary, you
can rename the file back to the original name when you're done. If
you're exporting, export to an approved extension and rename the file
when you're done.
 
Back
Top