Ok, I am having major problems here. Goal:
Open Up MSAccess
User opens up dialogue form which displays available Word Docx's
User Selects a specific Word Document
MSAccess query runs, stuffs data into a separate database using make table query.
Word Document Opens
Displays correct information into predefined Mail Merge Fields
User Prints document
Closes without Save
I have this working on one machine via an .odc driver. I used the %windir%\syswow64\odbcad32.exe to set up the connection. I even reverted to making the "Other database" an mdb and selected Jet 4.0 as the provider.
HOW DO I TRANSFER THIS TO TWO OTHER Machines?
When I click the Word Document from the list within MSAccess, the dialogue pops up asking me to select the datasource. It asks me this everytime.
The client wants the document to open everytime without prompting for "select data source." and to have the current information displayed.
I feel like I am going about the data connection wrong.
I did add SQLSecurityCheck or whatever it was that I found on internet.
Thank you for your kind help.