Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Washington, Washington, USA
    Thanked 0 Times in 0 Posts

    Using Access from within Word (XP)

    I created an application within Word that uses data from Access to fill a variety of controls on several different forms. The application works fine on the system on which the data is stored; that system has Office Professional installed. The networked computer has Access installed but not licensed. (It appears they purchased Professional for one system and Standard for the other, but installed both from the same CD.) Anyway, when I try to run the application on the second computer, Access prompts me for a license number. Will removing Access fix this problem, or does Access need to be installed before Word can use an Access data file? The second option doesn't seem likely, and I know I've used Access data for mail merges in Word on systems without Access installed, but I thought I'd better ask the experts before I head out there on Thursday to try to fix things. Oh, if it makes a difference, the Access database contains linked data from a FoxPro database using ODBC. I don't know much about using ODBC, but it does say something in the wizard about Machine Data Sources being specific to that machine. Can I set up an ODBC connection on a machine that doesn't have Access? Have I totally confused the issue? Many thanks for your always helpful advice.


  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: Using Access from within Word (XP)

    <img src=/S/confused.gif border=0 alt=confused width=15 height=20> <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Who me <img src=/S/question.gif border=0 alt=question width=15 height=15> Of course!
    As I understand it, using OLE DB data sources for Word merges should not require Access to be installed on the PC, especially if you are reaching across a LAN to get at an MDB on another PC. However, if you are using ODBC linked tables to FoxPro, I seem to remember it being a different kettle of fish. Linked tables can't be daisy-chained (if that makes any sense) - in other words, you can't link to a table in another database if that table is really a link to a table in a third database, (or an Excel worksheet, or DBase, or SQL Server or whatever). That said, I'm not sure how the OLE DB provider in Office XP works with tables. Hopefully someone else can shed more light on this "interesting" subject.

Posting Permissions

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