Hi,
I have a access front-end and an sql server back-end.
I created this form and created a dsn file as a connection between the two, this file uses SQL authentication and set up the the user login details and permissions on the sql back-end, also saving the password when linking the tables.
Everything works fine in the form while I am on the server where I have created the form originally.
although when I moved the accde and dsn file to another server, the user logging in gets an error that Login failed for user <Domain><JohnDoe>.
Is there any way of combining a DSN and accde so this error doesnt occur and the user can log in freely?
James