Microsoft Access import of Excel data

[Carl Parker]

I have an NT Terminal Server running Access 2000, but when I try to import an excel file into MS Access, nothing happens. If I do this on my 2K workstation, everything works fine. The Acess db and Excel file are on a Novell server. I can open the file seperately on the Terminal server session, but imports fail.
We have two Terminal Servers and this functionality works fine on the other terminal server so I know that it is a Terminal Server problem.
Thank you,

Leto the Just.

 

[The_Doc_Man]

First place I would look is a security issue. Since you are on Win2K Server, you just about MUST have a login ID. Is it the same ID from both places you try? Is there a difference in the security settings that apply from the two different places?

 

[Carl Parker]

Yes

I am logged on as the administrator to the 2k domain and the Novell server