access to sql server, windows authentication, error dialog on database open if no permission RRS feed

  • Question

  • Migrated an application to have a SQL Server back end.

    In the Access version, everybody could log on.

    Those unknown to the database would get read-only access.

    Moving to SQL Server, trying to use Windows Authentication.

    My plan is to have an APP_USERS group, which will allow the users to connect to the database.

    This much I've got working.

    My problem is that if Access can't get access to the SQL database it pops up a dialog to prompt the user for a connection.

    What I'd like is to to be able to trap this error in VBA, present the user with an error dialog, and then close the database.

    The error happens as the database is loaded, though, and before any forms or macros have a chance to run any VBA code.

    Has anyone come across this?

    Is there a workaround?


    Friday, February 16, 2018 12:10 PM


All replies