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

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?

MTIA,
e.

Answer 1

You may want to read the below thread. I'm assuming you are referring to the issue with using linked tables so it may apply to your scenario:

https://social.msdn.microsoft.com/Forums/office/en-US/2426e81d-ce90-466f-b3e9-eb6666d37efe/trapping-network-connection-issues-when-access-loses-network?forum=accessdev

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 2

Hello exotericist,

Has your original issue been resolved? If it has, I would suggest you mark the helpful reply as answer or provide your solution and mark as answer to close this thread. If not, please feel free to let us know your current issue.

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].