Copying a Database

[DDrowe]

I created a database and I would like to copy it and distribute it to other
facilities within our company. However, when I copy it and then try to open
it, it tells me that it is read-only and that I can not makes changes. My
forms don't even show the requried boxes.

Any help is greatly appreciated.

 

[Stefan Hoffmann]

hi,

I created a database and I would like to copy it and distribute it to other
facilities within our company. However, when I copy it and then try to open
it, it tells me that it is read-only and that I can not makes changes. My
forms don't even show the requried boxes.

This should only be a problem, when you use Access Security and you
don't distribute the according .mdw.

The most common problem are the permissions on the file itself and the
directory where it is stored. You and your users need (almost) full
access to the directory where the file is stored. The two things which
may gone wrong:

1) The file was copied to a directory under \Program Files\. Normal
users have only read permissions per default on directories.

2) The file was copied from a read-only medium (CD-ROM etc.). File
copied from such a medium are marked read-only.


mfG
--> stefan <--

 

[pddxxx]

I agree with Stefan. I've seen this problem where the user did not
have sufficient permissions to create a file in the folder where the
database resides. Since Access needs to create the .ldb file when the
db opens, its inability to do this will put it in read-only mode.

Peter De Baets
http://www.peterssoftware.com

 

[aaron.kempf]

If your data keeps getting corrupted-- you need to move to SQL Server.
If your application keeps on throwing a tissy fit-- you just need to
upsize to SQL Server and your nightmares are all gone.

Giving the people the ability to read / write / delete / create your
important data?
You just can't trust _ANYONE_ enough to poke through your databases.

-Aaron