Hi All,

I have an adp application that works beautifully on my computer. When
I move the app to a shared folder on a different computer, it does not
work.

I realize that the application, where it is sitting, prob does not
have permission to access SQL server. How can I set up this adp app on
a shrec computer successfully?

Well, if it doesn't have access to the SQL-Server, then you have to solve
this problem on the SQL-Server itself and not on the client side (the ADP
application). There are many reasons why any client application (and not
only an ADP application) can't connect to a SQL-Server; however, you haven't
given any detail at all on your current setting; for example, where the
SQL-Server itself is located or what kind of login (Windows account
(Integrated Security) or SQL-Server Login Account) you are trying to use.

One place to start looking would be at:
http://www.linglom.com:80/2009/03/28...-2008-express/

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)


"Tangier" <(E-Mail Removed)> wrote in message
news:451d26a2-0be3-43b7-a5f2-(E-Mail Removed)...
> Hi All,
>
> I have an adp application that works beautifully on my computer. When
> I move the app to a shared folder on a different computer, it does not
> work.
>
> I realize that the application, where it is sitting, prob does not
> have permission to access SQL server. How can I set up this adp app on
> a shrec computer successfully?