Showing the Tools menu in Access 2003

[Guest]

I have produced a database for a company. There is one problem the users are
having with it and I wondered if it was possible for some guidance please on
this please?

I provided the database in Access 2000 and they have converted it to Access
2003. There are actually two databases: one main database has the structure
and is linked to another database containing the data so that I can
modify/update the main database periodically without affecting the records in
the other.

The problem they are having is that they want to password protect it now
because it is going onto a network and will be accessed by other users. They
say that the Tools menu is hidden so thay cannot add a password. I told them
to open the database while pressing the SHIFT key. This shows the Tools menu
when the database is opened with the 'Open' command but not when opened with
'Open Exclusive' which they need to do in order to password protect it. In
this case the Tools menu does not appear.

I cannot replicate this in Access 2000 so I wondered whether this was
something particular to Access 2003? Any help would be grreatly appreciated!
Thanks. David.

 

[Guest]

Hi David,

It sounds like your customer is not following your instructions properly. I
don't have Access 2003, but the steps you gave should work for them. However,
perhaps a better alternative would be to use Windows security to lock down
which users have RWCD privileges for the shared folder that contains the
back-end database. Using the built-in password feature only raises the bar a
small amount. It won't keep an experienced hacker out of their database.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have produced a database for a company. There is one problem the users are
having with it and I wondered if it was possible for some guidance please on
this please?

I provided the database in Access 2000 and they have converted it to Access
2003. There are actually two databases: one main database has the structure
and is linked to another database containing the data so that I can
modify/update the main database periodically without affecting the records in
the other.

The problem they are having is that they want to password protect it now
because it is going onto a network and will be accessed by other users. They
say that the Tools menu is hidden so thay cannot add a password. I told them
to open the database while pressing the SHIFT key. This shows the Tools menu
when the database is opened with the 'Open' command but not when opened with
'Open Exclusive' which they need to do in order to password protect it. In
this case the Tools menu does not appear.

I cannot replicate this in Access 2000 so I wondered whether this was
something particular to Access 2003? Any help would be grreatly appreciated!
Thanks. David.

 

[chakatheapeman]

Why not make a custom tool bar for the project?