Advertisement

01.27.2008 at 05:47AM PST, ID: 23114539
[x]
Attachment Details

How to query Linked Server from MS Access

Asked by jleebethune in Access Coding/Macros, SQL Query Syntax, SQL Server 2005

Tags: Microsoft, Access, 2003

I have successfully created a Linked Server on Microsoft SQL Server Express 2005 with the following:
Server is at 192.168.0.106\sqlexpress

sp_addlinkedserver @server = 'LEDGERS',
@srvproduct = 'VFP',
@provider = 'VFPOLEDB.1',
@datasrc = 'c:\FileServer\Ledgers.bak\Company\Pyrotech'

I can also connect and query this Linked Server using a query editor.  I have been using QueryCommander downloaded from SourceForge.  Sample query that works from 192.168.15.110:

SELECT * FROM LEDGERS...accounts where aufiscyear=2007

Cannot figure out how to connect and query this linked server from Microsoft Access 2003 / Visual Basic.

Any help is appreciated.  Thanks in advance

Start Free Trial
 
Keywords: How to query Linked Server from MS …
Title
1 Running DTSX packages on SQLExpress
2 VFP SQL Select from MySQL
3 SQLExpress Problems
4 SQLExpress
5 Need to Calc Invoices to Pay
6 How do I get a Letter size (not A4) …
 
Loading Advertisement...
 
[+][-]01.27.2008 at 06:39AM PST, ID: 20753866

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 07:12AM PST, ID: 20753932

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 07:54AM PST, ID: 20754027

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 08:27AM PST, ID: 20754199

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 08:37AM PST, ID: 20754224

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 01:38PM PST, ID: 20755349

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 02:23PM PST, ID: 20755522

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 03:52PM PST, ID: 20755834

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 03:57PM PST, ID: 20755852

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.27.2008 at 04:04PM PST, ID: 20755869

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.01.2008 at 07:17AM PST, ID: 20797162

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, SQL Query Syntax, SQL Server 2005
Tags: Microsoft, Access, 2003
Sign Up Now!
Solution Provided By: jleebethune
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628