Credentials of ADP on a network share

[hominamad]

Hi - Currently I'm using a model where I have an ADP project residing on a network share. It is connecting to a SQL Server 2005 server on another machine. I have a few questions about how things work when accessing it this way.

When opening on a network share, does VB code running in Access think it's on the local machine running it? For instance, if I have functions that use the file system object, is it looking at the machine's file system hosting the file, or the system accessing it?

Same goes for database access. Let's say the remote machine hosting the ADP can "see" the database it's connecting to. But the machine opening it on the share cannot. Will this work then? Does it route requests through the machine hosting the ADP? I guess this is similar to how a webserver would work.

Thanks..H

 

[lameid]

Access opens the ADP locally just like Word or Excel can open a document on the network so everything the ADP does should be relative to the local machine.