I have built a linked server which links my SQL Server database to an Access DB. Using this object someone is able to see all tables in Access. What I would like to do is to isolate it just to 1 ...
Is there a way I can check SQL Server to see who is accessing it using Microsoft Access (as opposed to a website)? I'm using SQL Server 2008R2 with the default logging settings.
I'm currently managing a "db" in Access (meh). A complex structure of masks and VBA scripts was built over this "db". What I'd like to do is change the Access datasource from Access itself to SQL ...