Microsoft Office Access is unable to save the database properties

G

Guest

After setting user security on a database I can not change the database
properties.
When I go into file, database properties and change the title, I am told
Microsoft Office Access is unable to save the database properties.
 
J

Jeff Conrad

in message:
After setting user security on a database I can not change the database
properties.
When I go into file, database properties and change the title, I am told
Microsoft Office Access is unable to save the database properties.

Yep, I've seen this personally myself..
Only remedy I found was to import all of the database objects
into a new container. Apparently something became corrupted.
MVP Dirk Goldgar once told me that he saw this when:
The only time I've seen anything like it was when I was work­ing on a
database in Access 2000, then copied it to my laptop and too­k it with me
on vacation, where I worked on it using Access 2002, but wit­hout
changing the database file format. As I recall it, I had st­ored some
information in the database properties when I was working in­ Access
2000, and then I modified the property when I was working un­der Access
2002. When I returned home and copied the updated version b­ack to work
on it with Access 2000 again, I found that I could no longer­ access the
database properties, and there was no way to recover them.

It turns out that A2K and A2K2 store the database properties­ in
different locations in the database file, and if you let A2K­2 store the
database properties, you won't be able to read them from A2K­ -- at
least, that's the way I remember it. I was quite upset abou­t the fact
that one can effectively lose data this way, with no warning­ that
anything of the sort could happen. When I complained to MS,­ however,
the answer was "This behavior is by design," which is their ­way of
saying, "Whether it's a good behavior or a bad behavior, we ­have no
intention of changing it." I was not happy

Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
 
G

Guest

Helen,

You have to open your database in "Exclusive" mode in order to put in
any type of security measure.
 

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