Senin, 25 Februari 2013

Re: [MS_AccessPros] Linked table Question

 

John

I see this

ODBC;DSN=PeopleSoft ;Trusted_Connection=Yes;APP=Microsoft Office 2010;;TABLE=dbo.R&D-CURRENTEMPLOYEES

 
Jim Wagner
________________________________

________________________________
From: John Viescas JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, February 25, 2013 1:16 PM
Subject: RE: [MS_AccessPros] Linked table Question


 
Jim-

In the Access front end, open the table in Design view (ignore the warning
message about it being a linked table). Open the table properties and look
at the Description - that should be a copy of the Connection property that
points to the table on SQL Server. That should give you a clue as to
whether you're pointing to the same table.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Monday, February 25, 2013 8:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Linked table Question

Hello all,

I have ventured into learning some SQL and I am using SQL Management studio
12 the free version. I have created some tables and have linked the tables
in an Access database. But the table counts for both tables are widely
different. I am not sure if I have them connected, and so I do not know what
the linked table is looking at. The SQL has 442 records and the Linked table
has 590. I see the path as to the SQL database table, so I am confused. Is
there something that I am missing. I created the ODBC connection and the
test works.

Thank You

Jim Wagner

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar