Andrew,
I shout at myself all the time over that name. It has caused so many issues. It began only as a Hyperion query. I would love to change it but there are so many objects associated with it in so many databases. I was not thinking when I did that.
I will try the currentdb and not shout back
Jim Wagner
________________________________
________________________________
From: acravenrohm yahoo@craven.de>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, February 27, 2013 1:50 PM
Subject: Re: [MS_AccessPros] Linked table Question
If the user has some VBA knowledge then instead of deleting/re-adding it would be easier to use:
currentdb.TableDefs("This_is_my_Table_Name").RefreshLink
(P.S. Please, don't shout about the use of CurrentDB, one can use some other, equivalent, object as one's tastes desire.)
(P.P.S. I would like to shout at the person who chose to name a table with an ampersand in the name and to severely tsk-tsk the use of a minus sign in the table name but, who am I to judge :-) )
--- In MS_Access_Professionals@yahoogroups.com, John Viescas wrote:
>
> 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]
>
[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 (9) |
Tidak ada komentar:
Posting Komentar