Tagged Questions

6
votes
3answers
175 views

What would I look for in SQL Server to determine if a user connected with Microsoft Access?

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.
2
votes
1answer
310 views

Is it possible to change the Access data source to SQL Server?

Sadly I found myself in an akward position. I'm currently managing a "db" in Access (meh). A complex structure of mask and vba scripts was built over this "db". What I'd like to do is change the ...