I have an Access 2007 application that uses SQL as the back end. I created a DSN-Less connection using these instructions from MS (http://support.microsoft.com/kb/892490
). I have this app using SQL login connection string so all the users would have to do us run the application and I would not have to give them access to the database to run the app. But the only way to get this to work was to grant them access to the database otherwise they would get an cannot access the database error.
I am putting in all the parameters so the code uses the SQL login
"RemoteTableName", "ServerName", "DatabaseName", "SQLLoginAccount", "SQLLoginPassword")
I have stepped thru the code and it is running the correct code.
Should I be able to have the users connect to this database without adding them to the SQL security?