Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

My domain account has access to our MS-SQL server where the database resides, so I never experienced this issue.

When I gave the Access .mdb file to one of our regular users, he was unable to use the file without logging in. I created an account on the database before setting the Access file up and entered the username and password I setup, but it hasn't saved it. Instead it attempts to use their domain account as logged into their Workstation.

Is it possible to save this? Several users will be using the file so I'd rather not give them SQL access rights.

share|improve this question
This would be more appropriate on dba.SE. – BBlake Nov 12 '12 at 12:44

closed as off topic by CharlieRB, BBlake, Dave Rook, Diogo, Gnoupi Nov 12 '12 at 14:11

Questions on Super User are expected to relate to computer software or computer hardware within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.