Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 658
  • Last Modified:

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?
0
Morgs77
Asked:
Morgs77
  • 2
  • 2
2 Solutions
 
als315Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now