Open as Read-Only

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • colemanj4
    #1

    Open as Read-Only

    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,
    Tags: None
    • lyle fairfield
      #2
      Re: Open as Read-Only

      On Apr 21, 10:50 am, colemanj4 <colema...@gmai l.comwrote:
      why can't
      Microsoft make products of the same family have the same advanced
      functions?
      It's because they are adopted.

        Comment

        • colemanj4
          #3
          Re: Open as Read-Only

          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...@gmai l.comwrote:
          >
          why can't
          Microsoft make products of the same family have the same advanced
          functions?
          >
          It's because they are adopted.

            Comment

            • lyle fairfield
              #4
              Re: Open as Read-Only

              On Apr 24, 7:35 pm, colemanj4 <colema...@gmai l.comwrote:
              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...@gmai l.comwrote:
              >
              why can't
              Microsoft make products of the same family have the same advanced
              functions?
              >
              It's because they are adopted.
              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.




                Comment

                Previous template Next
                Working...