• todd.ayers (5/7/2013)


    OK... so in lieu of access what could I use to act as a GUI for the users?

    Well, there's the rub. There isn't both an easy and effective way to put together interfaces. Access using forms and no code is easy, but not terribly effective. Anything else requires code which generally means it isn't easy.

    I'd use Access. For example, I have an Access app connected up to a Windows Azure SQL Database that our local Boy Scout troop is using. It works, but I don't want to program stuff, so it doesn't work terribly well. But considering the number of simultaneous connections in the system (usually 1) there's not an issue.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning