ACCESS FEED: RE: [MS_AccessPros] Linked table Question

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@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]

[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.