Post reply

Using Access ADPs when Enterprise Manager isnt loaded

  • May 5, 2004 at 9:54 pm

    #152136

    I don't know how many of you have experienced this, but I've had to work on workstations that didn't have Enterprise Manager loaded and until I learned about using Access ADP's, I used Excel and VBA to view the data.  Not very pretty.

    The AWESOME thing about ADP's is you don't need a DSN, you can edit data, schema, views, functions, etc.

     

    You don't need to do anything to load all of the objects from the database into the ADP.

     

    The only negative I've seen is the lack of multiple database views, you have to create an ADP for each Database.

     

     

  • May 7, 2004 at 5:15 am

    #505634

    They come in very handy and are easy to create on the fly.

  • May 7, 2004 at 5:45 am

    #505639

    You only have to change the connection information if you want to use the same file, but I find it easier to use one db with a meaningful name and leave the connection information intact

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply