Error 2950 with TransferSpreadsheet (1 Viewer)

[Fasopus]

So all of my users can run my macro to import data from excel into the access database, however sometimes they will ranomly get the following error

Action Failed
Macro Name: Import
Condition: True
Action Name: TransferSpreadsheet
Arguments: Import, 10,Offline, O:\Access\ImportOff,Yes,
Error Number: 2950

Im not exactly sure why this error is appearing, the MS documentation I read stated that this error occurs when the database is not in a trusted location but I have checked and confirmed that it is, does anybody know anyway to resolve this?

 

[Fasopus]

I think I may have solved it, simply added a range parameter to the macro call