MS SQL user problems

[petegoodman]

Hi,

I am having problems using microsoft sqlserver 2000 with microsoft access. I have the server set up on a remote computer and I am trying to allow users to connect to the database through microsoft access.. The problem is occuring because only network administrators can log onto the database and regular users cannot. Any ideas to making this happen?

 

[jrbarnett]

You need to grant the normal users access to SQL Server.

Consult the database / network administrator on setting this up properly, because the exact method of doing it will depend on your server settings. Try Forum962 if you need more help on this.

John