AccessXP Startup switch /ro

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • bobh

    #1

    AccessXP Startup switch /ro

    Hi All,
    In the desktop shortcut I added the /ro switch to the command line

    \\Homf6\Vol2\Li feComp\ComonDbs \AVA\Apps\AvaXP .mdb /ro

    and the db opens but I can still change data that is displayed on a
    form.

    So, what am I missing?? If the "/ro" switch is suppose to open the db
    as read-only then why is it letting me change data thru a opened form.
    thanks
    bobh.

  • Trevor Best

    #2
    Re: AccessXP Startup switch /ro

    bobh wrote:[color=blue]
    > Hi All,
    > In the desktop shortcut I added the /ro switch to the command line
    >
    > \\Homf6\Vol2\Li feComp\ComonDbs \AVA\Apps\AvaXP .mdb /ro
    >
    > and the db opens but I can still change data that is displayed on a
    > form.
    >
    > So, what am I missing?? If the "/ro" switch is suppose to open the db
    > as read-only then why is it letting me change data thru a opened form.
    > thanks
    > bobh.
    >[/color]

    Is it bound data on the form?

    --
    [OO=00=OO]

    Comment

    • Trevor Best

      #3
      Re: AccessXP Startup switch /ro

      bobh wrote:[color=blue]
      > Hi All,
      > In the desktop shortcut I added the /ro switch to the command line
      >
      > \\Homf6\Vol2\Li feComp\ComonDbs \AVA\Apps\AvaXP .mdb /ro
      >
      > and the db opens but I can still change data that is displayed on a
      > form.
      >
      > So, what am I missing?? If the "/ro" switch is suppose to open the db
      > as read-only then why is it letting me change data thru a opened form.
      > thanks
      > bobh.
      >[/color]

      Is it bound data on the form?

      --
      [OO=00=OO]

      Comment

      • bobh

        #4
        Re: AccessXP Startup switch /ro

        Yes it is......

        Comment

        • bobh

          #5
          Re: AccessXP Startup switch /ro

          Yes it is......

          Comment

          • shumaker@cs.fsu.edu

            #6
            Re: AccessXP Startup switch /ro

            I think I read something about modifying your shortcuts to point to the
            actual Access program (not the database file) and have the database
            file location as the parameter, and the command line options.

            Comment

            • shumaker@cs.fsu.edu

              #7
              Re: AccessXP Startup switch /ro

              I think I read something about modifying your shortcuts to point to the
              actual Access program (not the database file) and have the database
              file location as the parameter, and the command line options.

              Comment

              • shumaker@cs.fsu.edu

                #8
                Re: AccessXP Startup switch /ro




                Yep. I knew I had seen it soemwhere.

                Comment

                • shumaker@cs.fsu.edu

                  #9
                  Re: AccessXP Startup switch /ro




                  Yep. I knew I had seen it soemwhere.

                  Comment

                  • bobh

                    #10
                    Re: AccessXP Startup switch /ro


                    Yep...

                    I did that

                    "C:\Program Files\Microsoft Office\Office10 \MSACCESS.EXE"
                    \\Homf6\Vol2\Li feComp\ComonDbs ­\AVA\Apps\AvaX P.mdb /ro

                    and even thou I get the message saying the 'database is read-only' I
                    can still change data that's displayed in a bound form.
                    I'm wondering if it has something to do with the fact that it's a split
                    database(front-end/back-end)
                    bobh.

                    Comment

                    • bobh

                      #11
                      Re: AccessXP Startup switch /ro


                      Yep...

                      I did that

                      "C:\Program Files\Microsoft Office\Office10 \MSACCESS.EXE"
                      \\Homf6\Vol2\Li feComp\ComonDbs ­\AVA\Apps\AvaX P.mdb /ro

                      and even thou I get the message saying the 'database is read-only' I
                      can still change data that's displayed in a bound form.
                      I'm wondering if it has something to do with the fact that it's a split
                      database(front-end/back-end)
                      bobh.

                      Comment

                      • shumaker@cs.fsu.edu

                        #12
                        Re: AccessXP Startup switch /ro

                        Is it actually changing the underlying data in the AvaXP.mdb database?
                        Or are you saying the data is from a different source than AvaXP.mdb?

                        Comment

                        • shumaker@cs.fsu.edu

                          #13
                          Re: AccessXP Startup switch /ro

                          Is it actually changing the underlying data in the AvaXP.mdb database?
                          Or are you saying the data is from a different source than AvaXP.mdb?

                          Comment

                          • bobh

                            #14
                            Re: AccessXP Startup switch /ro

                            Yes it is......
                            I load the form, select a policy nbr, change a value, close the form.

                            go to database window view, tables tab, directly open the table, find
                            the polcy nbr, check the field I changed via the form and it's changed
                            to the value I entered on the form.

                            bobh.

                            Comment

                            • bobh

                              #15
                              Re: AccessXP Startup switch /ro

                              Yes it is......
                              I load the form, select a policy nbr, change a value, close the form.

                              go to database window view, tables tab, directly open the table, find
                              the polcy nbr, check the field I changed via the form and it's changed
                              to the value I entered on the form.

                              bobh.

                              Comment

                              Working...