Our MSAccess applications use dsn-less connections with SQL Server Native Client (are distrubuted with Citrix).
While building a maintenance form for the Access users to perform various maintenance task.
I don't really give the average Access persons in my SQL Server.
What I would prefer is to have some kind of SP or Function that allows
to be run from a control button on an Access form and return the basic results.
Our SQL Databases are each on the order of 50 MB to 400 MB if that needs to be known.
Any suggestions would be very welcome.