Creating new user

Hello all,
I have downloaded the evaluation version to Sql Server 2000. I have a front
end database that is Access 2000 attached to the SQL server 2000. What do I
need to do to get another user to be able to get into the database?
I have gone into the sql server and added another database user and gave him
database role membership as public and granted him permissions to all
tables, but he still cannot get in. What am I missing? (I am brand new to
all of this!)
Thanks,
GaleWhats the error message?
>--Original Message--
>Hello all,
>I have downloaded the evaluation version to Sql Server
2000. I have a front
>end database that is Access 2000 attached to the SQL
server 2000. What do I
>need to do to get another user to be able to get into the
database?
>I have gone into the sql server and added another
database user and gave him
>database role membership as public and granted him
permissions to all
>tables, but he still cannot get in. What am I missing?
(I am brand new to
>all of this!)
>Thanks,
>Gale
>
>.
>|||I think I have figured it out now.
I am just having problems linking tables now. In Access 2000, once you
linked the front end of the database you could copy it to another work
station and it would be automatically linked to the backend. I don't think
it works that way when you link a front end with the SQL server. I have
mine on my work station successfully linked and I can get into it. I copied
the front end onto another work station and the linking didn't work. I had
to link it all over again. When I link the tables they always end up with a
name like dbo.Agency. All the reports and forms in the front end of the
database are looking for a table named "Agency". So I have to go in and
change the names of the tables in the front end and take all the "dbo" off
of them. Then the forms and reports work.
Is there a way around this? Can you copy a front end and paste it on
another machine and should it still be linked? How can I get the "dbo" off
the front of all my tables when I link them?
Goodness for all the questions, but I am just starting and prefer to play
around and get to know the lingo a little before I delve into a book.
Thanks,
Gale|||OK, figured out that problem to. I needed to set up a user DNS on the
machine and then copy the access front end over and it worked!
Gale