ODBC errors on terminal server

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)
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
ODBC Failure, error 18456 1
Are there any public SQL-Server databases available for testing Ac 5
On 64bit MS2003 server we cannot get MS-Office to conn with ODBC 0
Wrong wizzard when connecting to ODBC 0
split data base using ODBC connection 1

Top