Sql and RemotesLocked
I have a sql database w/access 97 front end. Loacal users are working fine – its the remotes, that cant work. I have tested the connectivity to sql w/isql, and seems good, but when they launch the front end, they are prompted for a password. They enter a KNOWN working password and get “ODBC -Connection to “database” failed.” – thats it, no other messages. Anyone have any clues about this?