Andrew-
Good thoughts. Also, if you've changed the design on the back end, you need
to delete the linked table and relink it.
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 acravenrohm
Sent: Tuesday, February 26, 2013 10:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Linked table Question
For some reason I can't answer the original posting so sorry for butting in
John.
Back in the dim-and-distant past, if you linked certain tables to Access you
would get different record counts as the driver would return the deleted
records as well as the non-deleted ones. I don't for one moment (OK, perhaps
one very brief moment) believe this is your problem but it would be
interesting to know which ODBC driver you are using and how you set the DSN
up.
Another idea would be to pick a table with a manageable number of records
and do a quick visual scan to see which records show up in Access that don't
on the original. Incidentaly, where are you readng the recordcount from in
both cases?
Yours, Andrew
--- In MS_Access_Professionals@yahoogroups.com
, Jim Wagner wrote:
>
> 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
> 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@... >
> 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]
>
[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 (7) |
Tidak ada komentar:
Posting Komentar