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