>>>Have setup a Remote View which connects to an Access Database.
>>>
>>>Every time I open the View, a prompt to specify the Access mdb appears.
>>>
>>>Is there any way to suppress appearance of this prompt?
>>
>>Could you post the code of the View?
>>How do you connect to Access DB?
>
>Via ODBC
Check SQLSETPROP() function, esp. for DispLogin.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.