How do I create a Linked Server in SQL Server 2005 to a password protected Access 95 database?
- by Brad Knowles
I need to create a linked server with SQL Server Management Studio 2005 to an Access 95 database, which happens to be password protected at the database level. User level security has not been implemented.
I cannot convert the Access database to a newer version. It is being used by a 3rd party application; so modifying it, in any way, is not…