Transferspreadsheet not working

[Guest]

I used DoCmd.Transferspreadsheet method to import data from several Excel
files to Access database and run queries and export the queries to Excel
reports. Our MIS department set up a secure folder and a usergroup to access
the database through a Citrix server. Suddenly all transferspreadsheet events
stopped working.
I don't know the reasons behind this.
I copied all the files to a different folder (away from the secured folder)
and changing the path names accordingly (I thought the path is the problem).
But it still doesn't seem to resolve the problem. Anyone know what's going
on? I changed the format of the worksheets that I am importing data from but
this shouldn't be a problem since the access table that data in imported into
takes the spreadsheet as a whole.
Please help me I am desperate to meet the deadline.
Toyfixer

 

[John Nurick]

Has anything else stopped working? for instance, can you create a new
database in the secured folder and import data into that from a
workbook?