Reading forms and reports information in .adp

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

    Reading forms and reports information in .adp

    Hi,

    I have Access 2000 and now I'm converting .mdb database to .adp and Sql Server 2000.
    In old .mdb application I have a query which handles msysobjects table
    (reading forms and reports information).

    How could I read information about forms and reports in .adp application ?
    Has .adp any information about forms and reports ?

    Is it possible to read from a table what forms and reports you have in
    your application in .adp/Sql Server 2000 environment ?

    I appricate any help

    Colpo
    Tags: None
    • Brendan Reynolds
      #2
      Re: Reading forms and reports information in .adp

      I don't think so - AFAIK, SQL Server is completely unaware of the existence
      of the ADP, or of any object, such as a form or report, that lives in the
      ADP rather than in the SQL Server database.

      You can get the information easily enough in code, however ...

      Dim aob As AccessObject

      For Each aob in CurrentProject. AllForms
      Debug.Print aob.Name
      Next aob

      --
      Brendan Reynolds

      "Timppa" <colpo@jippii.f i> wrote in message
      news:370b8cb1.0 402170336.22edc 932@posting.goo gle.com...[color=blue]
      > Hi,
      >
      > I have Access 2000 and now I'm converting .mdb database to .adp and Sql[/color]
      Server 2000.[color=blue]
      > In old .mdb application I have a query which handles msysobjects table
      > (reading forms and reports information).
      >
      > How could I read information about forms and reports in .adp application ?
      > Has .adp any information about forms and reports ?
      >
      > Is it possible to read from a table what forms and reports you have in
      > your application in .adp/Sql Server 2000 environment ?
      >
      > I appricate any help
      >
      > Colpo[/color]


        Comment

        • Timppa
          #3
          Thanks !

          Hi Brendan,

          Thanks for your help !

          Colpo



          "Brendan Reynolds" <brenreyn@remov ethisindigo.ie> wrote in message news:<7EqYb.309 5$rb.58734@news .indigo.ie>...[color=blue]
          > I don't think so - AFAIK, SQL Server is completely unaware of the existence
          > of the ADP, or of any object, such as a form or report, that lives in the
          > ADP rather than in the SQL Server database.
          >
          > You can get the information easily enough in code, however ...
          >
          > Dim aob As AccessObject
          >
          > For Each aob in CurrentProject. AllForms
          > Debug.Print aob.Name
          > Next aob
          >
          > --
          > Brendan Reynolds
          >
          > "Timppa" <colpo@jippii.f i> wrote in message
          > news:370b8cb1.0 402170336.22edc 932@posting.goo gle.com...[color=green]
          > > Hi,
          > >
          > > I have Access 2000 and now I'm converting .mdb database to .adp and Sql[/color]
          > Server 2000.[color=green]
          > > In old .mdb application I have a query which handles msysobjects table
          > > (reading forms and reports information).
          > >
          > > How could I read information about forms and reports in .adp application ?
          > > Has .adp any information about forms and reports ?
          > >
          > > Is it possible to read from a table what forms and reports you have in
          > > your application in .adp/Sql Server 2000 environment ?
          > >
          > > I appricate any help
          > >
          > > Colpo[/color][/color]

            Comment

            Previous template Next
            Working...