I asked my boss one time if we should consider renaming the tables with the R&D on it, which is 14, spread over 70 databases and probably associated with many thousands of objects like queries, macros and vba code. She smiled and changed the subject before I asked again.
Jim Wagner
________________________________
________________________________
From: acravenrohm yahoo@craven.de>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, February 28, 2013 2:42 PM
Subject: Re: [MS_AccessPros] Linked table Question
Oh how we pay for the misdemeanours of our youth :-) As I said, "who am I to judge?" The naming and Collation sequence crimes of my past haunted me until I changed jobs, now I'm haunted by the crimes of others :-D
--- In MS_Access_Professionals@yahoogroups.com, Jim Wagner wrote:
>
> 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
> 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]
>
[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 (17) |
Tidak ada komentar:
Posting Komentar