ACCESS FEED: Re: [MS_AccessPros] Linked table Question

Liz

You might want to check our Links>Development Tools for more links to other useful free stuff.

V-Tools, SmartIndenter and mztools are the ones I can't live without.

Bill

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood wrote:
>
> I'm not seeing anything at www.scroll29.com and am very interested! :-)
>
> Respectfully,
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Thursday, February 28, 2013 5:30 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Linked table Question
>
> Jim
>
>
>
> Iâ€™d live with it. skroll29.com has a free suite of V-Tools for Access that has an excellent find and replace, but at this point itâ€™s much too risky to do something like that.
>
>
>
> Regards,
>
> Bill
>
>
>
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
> Sent: Thursday, February 28, 2013 2:36 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Linked table Question
>
>
>
>
>
> 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@... >
> 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]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>