Hi, I am using Windows 7 (64-bit) and am trying to setup a Word (2007) Mail Merge obtaining data from an password protected Access accdb (2007) database.
The database is split into a front-end and back-end.
Within Word using the Data Connection Wizard I have tried specifying the data source as 'other/advanced' and the OLE DB provider as
Microsoft Office 12.0 Access Database Engine OLE DB Provider
but having input the database location and name as the Data Source and the relevant password to the front-end (having accepted the Username as Admin) a Microsoft Data Link Error is reported via a pop-up stating :-
“Test connection failed because of an error in initializing provider.
Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
There are various parameters listed under the All option of the Data Link Properties but I was unsure if I needed to change anything.
I'm also unsure if what I have tried above is correct.
Thanks
The database is split into a front-end and back-end.
Within Word using the Data Connection Wizard I have tried specifying the data source as 'other/advanced' and the OLE DB provider as
Microsoft Office 12.0 Access Database Engine OLE DB Provider
but having input the database location and name as the Data Source and the relevant password to the front-end (having accepted the Username as Admin) a Microsoft Data Link Error is reported via a pop-up stating :-
“Test connection failed because of an error in initializing provider.
Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
There are various parameters listed under the All option of the Data Link Properties but I was unsure if I needed to change anything.
I'm also unsure if what I have tried above is correct.
Thanks