Word file to update Access DB when printing

[Imry]

I have a word file (.doc) and a Access DB.
What I want is that whenever the word file is printed, it will automatically
update the database accordingly (the DB has a field that says LastPrintTime).
Could this be done through VBA code in the word file? How?
Thank you.

 

[Malcolm Smith]

I have a word file (.doc) and a Access DB.
What I want is that whenever the word file is printed, it will
automatically update the database accordingly (the DB has a field that
says LastPrintTime).
Could this be done through VBA code in the word file? How?
Thank you.

Imry,

Sorry am a bit pushed for time right now, but you can do this very easy by
using ADO (Active Data Objects). This Library allows you to read/write
to most of the common databases.

So, have a look around for ADO and it's really easy.

- Malc