Connecting users to ADP on a network 1

[petegoodman]

I have set up a access database project and I am trying to allow users on separate computers to connect to it. I have put the SQL data file onto a central server with SQL server installed. I have put the access file on each of the computers that need to connect to the system. The problem occurs because only administrators on the network appear to be able to connect o the server. Are there any settings I can change to allow all general users to conect to the database?

Please Help!

Petegoodman

 

[danvlas]

Looks like you installed the SQL server for 'trusted connections'.

I'd uninstall SQL Server and re-install it with SQL Authentication (not Windows authentication).Don't use TRUSTED CONNECTIONS.

Try not to use named pipes, which will count as connections to the Windows server. TCP/IP only would do great.

I have this configuration and it's working really cool with ADPs over a WAN and the Internet.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[petegoodman]

Thanks Very Much, I'll give it a shot!

Pete