I am trying to connect to Access 2003 using linked server in SQL server 2005 .
I am able to make the connection to a secured access database after i changed the registry entry of system.mdb to the location of my workgroup information file .
After making the registry changes all my packages involving excel are failing . I am not sure why this is happening . If i change the registry entry packages are working fine but then i cannot make a connection to access database .
Has anyone faced a similar problem ?