connect to Access database from Word w/o Access on system

[THWatson]

Here's my puzzle, with a bit of a snag.

Access is on System One. A complete database that includes a number of persons with names, addresses, date of birth etc.

Access is not on System Two and, for complicated reasons, it's not wanted on that system. However, there is one report from the Access file that System Two wants to use.
It is largely more like a pre-printed form on which Access grabs the person's first name, last name and birth date, calculates the age of the person, fills those 4 things in on the report and prints it.

The report could be pre-printed for use in Word.

System two wants to take the pre-printed form, have mail merge fields for the four fields, the one using a Word field code to calculate the age from the DOB, grab the data for the person desired from the Access file and print.

Is there a way to connect to Access from Word, without having Access on System Two?

Tom

 

[acent]

Are you using the Word doc to do a mailmerge using the information in the access database?

I'm not a 100% fluent on the mailmerge, but you should be able to select an access database and if so, navigate to a shared folder where the database is. The other option is to set up an odbc connection on the machine with access, and then use that odbc connection on machine 2 with the Word doc.

I would take a look at odbc if this type of thing will be done on a regular basis.

Hope this helps.

"If it's stupid but works, it isn't stupid."
-Murphy's Military Laws

 

[THWatson]

I will check it out and make sure exactly how/if the two systems are linked.

Tom

 

[THWatson]

Nope, that's an additional problem. There is no linking between the computers, and due to circumstances it won't be done.

Seems to me the only recourse is to have Access put on System Two.

Tom