Question password protected 2007 accdb / mail merge / workgroup information file (1 Viewer)

cczgw1

New member
Local time
Yesterday, 23:51
Joined
Dec 10, 2014
Messages
1
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
 

Users who are viewing this thread

Top Bottom