Results 1 to 4 of 4
  1. #1
    pipermac is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2014
    Posts
    2

    Need a bit of guidance

    I have Server Inventory Database where everything is entered manually. I would like to add the ability to automatically update some of the data.



    Ideally this would be done via querying WMI and inserting the values retrieved.

    I would like to be able to have a button that when selected would query WMI of the server that is currently being viewed and update whichever records I define.

    Can anyone put me in the right direction for figuring out how to do this?


    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I dont know what WMI is, but if you can link it to an OCBC table then yes, you can update the db tables.
    If no odbc, then you can export to xl or txt, and import and update that way.

  3. #3
    pipermac is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2014
    Posts
    2
    WMI is a way of getting information from a server/Worksation. WMI can be queried with VB Code. Where I am stuck is how to take the information retrieved and inserting it into the database.

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Can you connect to it via ODBC?
    (send some code)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Need Advice / Guidance
    By ETCallHome in forum Access
    Replies: 5
    Last Post: 03-24-2014, 09:55 AM
  2. Need some general guidance
    By akrasodomski in forum Access
    Replies: 2
    Last Post: 04-13-2012, 05:54 AM
  3. Need a little guidance to get started.
    By cashflo in forum Access
    Replies: 3
    Last Post: 01-19-2012, 12:10 PM
  4. need guidance in DLookup
    By koolbugs in forum Forms
    Replies: 3
    Last Post: 03-22-2010, 09:15 AM
  5. Need guidance on database
    By yak600 in forum Access
    Replies: 0
    Last Post: 08-04-2009, 07:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums