I am trying to create a linked server on SQL server for MS Access database which is shared to me on network i.e. I do not have copy on my machine. While creating a linked server I am facing two issues: 1. How to create a linked server without using mapped drive or using UNC path to that database? 2. How to create that linked server with read only mode as I only need to import the data to SQL server ?
I know this is common question but I have been struggling this for past many days?
Thanks in advance!!
asked May 09 '12 at 09:18 PM in Default
If this is a one time import you can simply use the import/export wizard in SQL Server Management Studio.
If you are wanting to do it more than once and create the linked server you are going to have to use a UNC path for SQL Server service to be able to get to the file.
With regards to read only mode I don't believe that is an option with linked server objects. What can be done over that link is determined by the user permissions on either end. With Access you probably could setup an account that can only read the data.
answered May 10 '12 at 01:36 PM