I'm trying to set up a DSN file so that other users who do not have SQL Server installed are able to connect to an Azure database through MS Access. I've created the file on a network drive but I'm not sure what to do next. I have the address for the DSN file built into my VBA connection code. I've tried to find instructions on the Internet but I've been unsuccessful so far. Does anyone have experience doing this? Thanks.
You may have figured this out already as this response is 19 days later. But once the DSN file is created, it should be either given to the user to place somewhere or, more efficiently, placed on a network file location to which all users have access. Then when they go to link in Access they can select the DSN file option and then navigate to the file itself.