Hello,

I have a database that is on my company's network that everyone needs
to be able to see, but I only want certain people to change any data
in the database. Is there a way (like there is in Excel, why can't
Microsoft make products of the same family have the same advanced
functions) to set an option so that the database opens in read-only
mode unless a specific password is entered?

Thanks,

On Apr 21, 10:50*am, colemanj4 <colema...@gmail.comwrote:

why can't
Microsoft make products of the same family have the same advanced
functions?

It's because they are adopted.

Any real help pertaining to my question?

On Apr 21, 11:01*am, lyle fairfield <lyle.fairfi...@gmail.comwrote:

On Apr 21, 10:50*am, colemanj4 <colema...@gmail.comwrote:
>

>
It's because they are adopted.

On Apr 24, 7:35*pm, colemanj4 <colema...@gmail.comwrote:

Any real help pertaining to my question?
>
On Apr 21, 11:01*am, lyle fairfield <lyle.fairfi...@gmail.comwrote:
>

>

>

I guess it's not real help for you to understand that these "products
of the same family" have very different antecedents, were not created
by the same entities, and largely, are totally different in concept
and form. If I adopt a rock and George W Bush I shouldn't expect them
to be similar (except in intelligence, I suppose), just because they
are now part of the Fairfield family.

If I had to do what I think you want to do I would try:
displaying the Access/Jet data in an Excel sheet with linking or
simply a static load on open,
using Access security to control who may edit,
developing a reports-only Access application linked to the tables of
the first,
transferring the data to a database engine such as MS-SQL Server
capable of seeting and using discrete permissions
or
displaying the data in some sort of html-hta-asp application.

Probably the second last option is better than the others as it can be
implemented at a very low level and will be difficult to circumvent.