Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats. There is no connection type specific to Microsoft SQL ...

I'm new at this whole DBA thing, so maybe this is totally standard practice.<BR><BR>But we have a software vendor that wants remote access to our SQL server at an admin level to setup and install ...