Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-05-18
4
Medium Priority
?
655 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 40

Assisted Solution

by:als315
als315 earned 1500 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 40

Accepted Solution

by:
als315 earned 1500 total points
ID: 39178162
0
 

Author Closing Comment

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Loops Section Overview

824 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