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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar