I have an Access Database with local tables, linked Access tables and linked SQL tables that I am trying to query from an external application using VBScript. I can connect to the database fine and can query the local and linked access tables fine. When I try to query the linked SQL tables I get the following error:
The Microsoft jet database engine can not find the input table or query 'dbo_vw_BomEmployeesCustomFields'. Make sure it exists and that its name is spelled correctly.
The table does exist and it is spelled correctly. I can open the linked table fine from withing the Access Database.
Does anything need to be done differently for the linked SQL table, or are reasons why I would be getting this error?