Linked Server to protected Access db 1

[danvlas]

Hello All,

Anybody knows how to setup a linked server to a password protected Access database?

BOL has instructions for Access databases with user-level security enforced, but nothing about database password.

Password removal is not an option at this moment.

Environment:
SQL Server 2005, MS Access 2003

Most helpful link returned by Google (of course, no solution...)

http://www.sqlservercentral.com/Forums/Topic125217-5-1.aspx#bm125449

Thanks in advance,




Daniel Vlas
Systems Consultant

 

[mrdenny]

I don't believe that it can.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[seaport]

There is a workaround.

You can create a new Access database and add linked tables from the secured database into the new databaes. Those linked tables will not appear as tables in the linked server. To go around that, create a query for each linked table. Those queries can be read and written just like tables.

Seaport

 

[danvlas]

Thanks, it worked.



Daniel Vlas
Systems Consultant