Solved

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

Posted on 2013-05-18
4
651 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 40

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 40

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

623 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