2002-11-05, 23:57 #1
- 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.
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!
+ 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!
2002-11-06, 02:13 #2
- Join Date
- Aug 2001
- Evergreen, CO, USA
- Thanked 42 Times in 42 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.Wendell