Linked server (access .mdb) "unspecified error"

[yetanotherjo]

I've linked an Access database to SQL Server 2005 express, and it works happily, so long as I run the stored procedures etc when I'm working directly on the server box. If I try to run it remotely ie. workstation on network using SSMSE, using a valid login, the database says it's linked, but eg. sp_tables_ex gives an error

"OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MyAccessDatabase" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MyAccessDatabase".

Any ideas on what's wrong?

 

[yetanotherjo]

I should possibly add that I am using Windows Authentication when on the workstation.