Merize:
The connection settings for SQL Server can be found by selecting the
Connection option on the File menu. You can check whether it is using
Windows or SQL Server authentication. You may also want to check whether
you have been granted appropriate permissions to the database you are trying
to access.
It would be helpful to know what version of Access/SQL Server you are using
as well as the details of any error message you are receiving.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
A user created a adp project and it works fine on their machine but it
will not connect to the MSSQL server on mine. I don't see a specific DSN
that it is using. Is there a way to find out?
THX,
Merize