Linked Server to secure Access DB from SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Linked Server to secure Access DB from SQL...

Linked Server to secure Access DB from SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

sushildar

Posted Friday, February 11, 2011 5:27 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, April 16, 2011 4:05 PM
Points: 2, Visits: 9

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 ?

Post #1062905

« Prev Topic | Next Topic »

Permissions