ODBC errors on terminal server

  • Thread starter Thread starter paul_tomlin
  • Start date Start date
P

paul_tomlin

We connect via terminal services to an excel spreadsheet that has an
ODBC link to an access database using a pivot table, when we try to
refresh the data within the excel spreadsheet we receive the following
error "the microsoft jet database engine cannot find the input table or
query....."

this works ok if the user connects to terminal services as the
administrator however if they connect as any other issue it won't work

Anyone got any ideas?

(have tried 2000 ts and 2003 ts)
 
It sounds like permission to access the mdb is denied.

Check the permission on the database and make sure the user has at least
Read permission.
 
Back
Top