SQL Server connection?

[KabirPatel]

Hi all,

I have an .adp that works fine on a number of people's laptops.

One of the users however, keeps getting an error message stating that SQL Server does not exist or access has been denied.

This particular user is definitely setup on SQL Server with dbo permissions. She can also ping the server.

I have tried creating a DSN and this doesn't work either.

I am at a loss as to why this error message is occurring given that she can see the Server and has definitely been setup.

Do you have any suggestions?

Thanks,
Kabir

 

[FoFa]

Well first you need to figure out if it is a driver or security issue.
Create a blank access DB, have her link a table to it from Sql Server using the security she uses in the application.
That might turn something up.