John,
I created the ODBC called PeopleSoft and the server name is looking at the correct server but the counts are not the same. other tables are not the same either. I suspect that I need to create a new ODBC and try again.
Jim Wagner
________________________________
________________________________
From: John Viescas JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, February 25, 2013 1:56 PM
Subject: RE: [MS_AccessPros] Linked table Question
Jim-
That looks like it is pointing to the database pointed to by the PeopleSoft DSN and the table dbo.R&D-CURRENTEMPLOYEES. If that's the table you're opening in Management Studio, the row counts should be the same.
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 Jim Wagner
Sent: Monday, February 25, 2013 9:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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]
[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 (5) |
Tidak ada komentar:
Posting Komentar