I'm trying to create DSN-less connection to one SQL Server table through MS Access. My problem is that it only works for me and I don't know why it doesn't work for anyone else. The Access database lives on a network and should be available for anyone to use. Other users get error messages when they try to open the linked table, however. Maybe the problem is that my user ID is somehow automatically populated in the connection string but I don't know how to substitute another user's ID when they open the table.
Does someone have experience with this? Thanks.