[AccessD] Changing Table Names

Keith Williamson Kwilliamson at RTKL.com
Thu Mar 5 11:23:31 CST 2009


Well...I'm the only one using it...so that part isn't a concern.  But,
certainly, I don't want to corrupt it.   :)   My application is fairly
simple....mostly just queries that churn and burn data from our SQL
accounting application.  Big concern on the corruption??

Keith Williamson | Associate, Asst. Controller | kwilliamson at rtkl.com 

RTKL Associates Inc. | 901 South Bond St. | Baltimore, MD  21231

410.537.6098 Direct | 410.276.4232 Fax | www.rtkl.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, March 05, 2009 12:21 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Changing Table Names


 > I usually use Rick Fishers Find and replace to do that type of
thing..

I also use this tool.

OTOH turning on the property in the database mostly kinda sorta works.

Options / General / Name autocorrect.

OTOH it might also corrupt your database, slow things down, allow users
to change things 
unintentionally etc.

John W. Colby
www.ColbyConsulting.com


Bill Patten wrote:
> Keith,
> 
> I usually use Rick Fishers Find and replace to do that type of thing..
> 
> HTTP://www.rickworld.com
> 
> HTH
> 
> Bill
> ----- Original Message ----- 
> From: "Keith Williamson" <Kwilliamson at RTKL.com>
> To: <accessd at databaseadvisors.com>
> Sent: Thursday, March 05, 2009 8:49 AM
> Subject: [AccessD] Changing Table Names
> 
> 
> Hey guys....does anyone have a utility for changing the name of a
table
> (or query), and have the change pass on to all dependent
> queries/forms/reports?
> 
> 
> 
> Thanks,
> 
> Keith Williamson | Associate, Asst. Controller | kwilliamson at rtkl.com
> 
> RTKL Associates Inc. | 901 South Bond St. | Baltimore, MD  21231
> 
> 410.537.6098 Direct | 410.276.4232 Fax | www.rtkl.com
> <blocked::http://www.rtkl.com/>
>
------------------------------------------------------------------------
--------
> The information contained in this communication is confidential, may
be 
> privileged and is intended for the exclusive use of the above named 
> addressee(s). If you are not the intended recipient(s), you are
expressly 
> prohibited from copying, distributing, disseminating, or in any other
way 
> using any of the information contained within this communication. If
you 
> have received this communication in error, please contact the sender
by 
> telephone at (410) 537-6000 or by response via e-mail and permanently
delete 
> the original email and any copies.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list