Multi-user security problem: Please HELP

M

Matt

Hi,
i have just created an .adp project that basically points to a SQL server
database that contains only ONE table. I simply perform a search on that
table on my form - no data update is necessary.

As owner/creator, and also being system administrator, It works for me.
However i have been trying to get my users to perform the search, but i
always get "Unable to log on to SQL Server" error. I am using Mixed mode -
SQL & NT Authentication, and have tried creating roles, and adding users
manually etc... but i can't seem to find the correct combination.

I am new at this, but I do understand how users/groups & roles/users perform
within SQL, so i think i am doing everything correctly.

any help would be greatly appreciated!

cheers...
M

PS: every time i try and create a connection to the sql connection via
access, I can't seem to find a valid user... i do not know SQL admin
password, but i have created the database from scratch using my information.
don't know if this doesn't help or not??
 
B

BJ Freeman

Matt:
if you are using SA SQL right and the other are using User Rights, then the
form has to have dbo. added to the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top