Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    SLC, UT
    Posts
    11

    Unanswered: Controlling another application from Access

    I have a commercially distributed software application called AVAware (I do not have access to the actual codes) that is an access database. One of the options programmed is to export data to an access database. When this is selected a new Access database with information about a specific project is created.

    I have an Access application (called IMS) which uses data from a project created in AVAware. Is there a way that I can open an AVAware file, Export the data (a File -> Export Project -> Microsoft Access menu option) and then import the data into IMS using, for example, an "update" control in IMS? If so, how would this code look? (Let's assume that the project that contains my project data is located at x:\Active Projects\2219 Hotel California\2219 Hotel California.APJ)

    Thanks
    Scott

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Scott

    The best route depends. Does the AVAware program simply export the contents of a tabl\ results of a query or does it do something clever (I'm thinking that there might be some VB code run for example)?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2003
    Location
    SLC, UT
    Posts
    11
    The source of the data (although I do not have access to the tables themselves) must be maintained in many different tables. So, as near as I can tell, it exports the results of queries to new tables in the exported .mdb file. I can interpret and manage the information once I can get it into my application, but I'm not sure how to get the data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •