are the users in access using hardcoded connection strings (in Access) to connect to SQL...if so can you please provide example?
what authentication method are you using for SQL?
does the Access app have a "log in" at the start?
are the computers that are connecting to SQL set up with local DSNs?
just a few q's to start off with.......
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day