Err#: -2147217865 Access Database with Linked SQL tables Query from external VBScript

Hi,

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?
Morgs77Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
als315Connect With a Mentor Commented:
You can't query linked tables outside Access
0
 
Morgs77Author Commented:
Thanks. I am able to query a linked table that is linked to another Access Database so I assume it is only non-Access linked tables that can not be queried from outside Access.

Am I able to connect to both the Access database and the SQL database at the same time using VBScript?

Any tips on how to connect to the SQL database?
0
 
Morgs77Author Commented:
Thanks very much. It is working now.
0
All Courses

From novice to tech pro — start learning today.