Report Offensive Message

Hello;

Pls kindly describe how i can link my ms access project to an sql server 2000 server in the same office but different computers.

I have used the client and server network utilities to setup the client system but each time i try to create a new instance on Ent manager, it returns access denied hindering the database from connecting.

I actually did not use any userid and password at the server end.Could that be the cause?

I tried connecting with the server TCP/Ip and name but yt no connection.

Thanks
Mike