Solved

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

Posted on 2013-05-18
4
641 Views
Last Modified: 2013-05-19
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
Comment
Question by:Morgs77
  • 2
  • 2
4 Comments
 
LVL 39

Assisted Solution

by:als315
als315 earned 500 total points
ID: 39177126
You can't query linked tables outside Access
0
 

Author Comment

by:Morgs77
ID: 39177172
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
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 39178162
0
 

Author Closing Comment

by:Morgs77
ID: 39178465
Thanks very much. It is working now.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This is about my first experience with programming Arduino.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now