I appologise if this is silly but I am trying. I upsized my access mdb
database to access project (adp) sql. It works very well now. my is I now
copy it and I palce it in myclients and if I am logged into the clients the
program works just fine but if my users are logged in it cannot connect to
the data base. I know I have to authorize them to logg in but I do not know
how. Please can someone walk me there slowly. I am using server 2003 and the
full installation of SQL. My clients are using office XP and windows XP

If you and your clients are in a trusted domain environment, how about using
Windows Authentication method to authorize your users?

Create a Windows Group and make your clients member of that group and then
go to SQL Server (2005\2000?).

If it's SQL Server 2005:
Then fire up SQL Server Management Studio and go to Security\Logins. Create
a login for that Windows Group and give them necessary rights and
permissions so that they will be able to connect to the mentioned database.

If it's SQL Server 2000:
Then fire up Enterprise Manager and go to Security\Logins. Create a login
for that Windows Group and give them necessary rights and permissions so
that they will be able to connect to the mentioned database.

--
Ekrem Önsoy



[quoted text, click to view]