Results 1 to 2 of 2
  • Thread Tools
  1. 3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cause Access to Open on another machine? (Office 2000 or Office 2003)

    This is going to sound nutty: but can I write a script in VBA or VBScript that will open an Access database to a given record but on another computer on my workgroup LAN? The reason I want this is that I have a telephony program installed which has VB scripting capability and I wanted this to check my contacts table and try to match a contact using the caller ID displayed for the incoming phone call. But the telephony board has to be on a different machine to the one that has the said Access application running - ie the IVR runs on machine B but the application runs on machine A on the LAN.
    Can this be done?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Cause Access to Open on another machine? (Offi

    I'm not aware of any way to do that using Access, and linking to the table from Excel or Word would be slow. I'd build a little ASP page on the computer hosting the database, and query the MDB and return the result in the browser. If you need to be able to "read" the page using VBA/VBScript, there is a Windows API call that retrieves web pages (VBA only), or you could automate IE and read the contents using MSHTML, or perhaps retrieve the page as a stream and read it as a big string...

Posting Permissions

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