Hi all
We have recently had a new Time and Attendance system installed that uses our SQL2000 server and I need to extract information on absences from it to import into our new Employment Law Software which uses an MDB back end along with an MDW...
The problem I have is when setting up a new sql DTS package and trying to put in the Access Data Source it fails in relation to the MDW saying something like :-
-----------------------------------------------------------
Error Source : Microsoft JET Database Engine
Error Description : Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
-----------------------------------------------------------
The Sqlserver is on ENERGYH1 server and the MDB is in a folder on ENERGYH2 server and I have the correct user and password for the MDB from the supplier...
Can someone please help me get past this hurdle.....
We have recently had a new Time and Attendance system installed that uses our SQL2000 server and I need to extract information on absences from it to import into our new Employment Law Software which uses an MDB back end along with an MDW...
The problem I have is when setting up a new sql DTS package and trying to put in the Access Data Source it fails in relation to the MDW saying something like :-
-----------------------------------------------------------
Error Source : Microsoft JET Database Engine
Error Description : Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
-----------------------------------------------------------
The Sqlserver is on ENERGYH1 server and the MDB is in a folder on ENERGYH2 server and I have the correct user and password for the MDB from the supplier...
Can someone please help me get past this hurdle.....