Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-03-2015, 02:14 PM   #31
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,578
Thanks: 88
Thanked 1,488 Times in 1,404 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Query off of a SQL Server

Still looks to me like the errors that happen when an inappropriate field is chosen as a PK during the import to Access.

Is a PK defined on the SQL table?

Is the same field indicated as the PK on the Access linked table?

If there is no PK defined on the SQL table, Access will ask for the appropriate fields to be selected during the import. If an inappropriate selection is made then exactly this type of error can happen.

Galaxiom is offline   Reply With Quote
Old 11-04-2015, 07:57 AM   #32
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,037
Thanks: 13
Thanked 4,064 Times in 3,999 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Query off of a SQL Server

Galaxiom has mentioned the PK issue twice and I don't see that it's been addressed. A poster on the MVP board agrees that it is a likely suspect, so please follow up on that.

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Tags
filter , odbc , query , sql

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Link to SQL Server with ODBC without risking original data in SQL Server? David Ball General 1 08-21-2015 07:59 PM
SQL Server Linked Server to Oracle slow --> OpenQuery Solution Rx_ SQL Server 2 05-19-2015 08:25 AM
Query and Sql Server FoFa Queries 9 03-01-2010 10:36 AM
SQL Server Query: Updating a column based on an aggregate query Banana Queries 3 03-16-2009 02:04 AM
Translating SQL server query to Access SQL query SimonSezz Queries 3 02-17-2009 08:36 AM




All times are GMT -8. The time now is 08:07 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World