What to do when the best laid plans change and mazes of legacy are
abolished, simplified, or built anew for contemporary reality.
A preliminary database was developed for tracking material through a
variety of manufacturing procedures. For a variety of business and
reality check reasons, the names of tables and columns need to be
changed, and some previously monolithic data tables are to be further
normalized.
What are some of the best tools for tracking down the complete side
effects of changing a relationship or changing the name of a table,
column, view, form, report, etc... The perfect tool would detect
dynamically generated queries used during event handling, and data
usages as directed by meta-data stored in control tables.
TIA,
Richard
13  7949 
On 2 Feb 2007 05:02:12 -0800, "Richard" <ri************ @devenezia.com>
wrote:
That's a tall order. I think only Biological Development Units can do
that.
-Tom.
>What to do when the best laid plans change and mazes of legacy are
abolished, simplified, or built anew for contemporary reality.
A preliminary database was developed for tracking material through a
variety of manufacturing procedures. For a variety of business and
reality check reasons, the names of tables and columns need to be
changed, and some previously monolithic data tables are to be further
normalized.
What are some of the best tools for tracking down the complete side
effects of changing a relationship or changing the name of a table,
column, view, form, report, etc... The perfect tool would detect
dynamically generated queries used during event handling, and data
usages as directed by meta-data stored in control tables.
TIA,
Richard
As far as I know, there is no "refactorin g software" for Microsoft Access.
And, as Tom said, BDUs will be required for the more complex tasks you
specify (just for my information, is there software that will do what you
request for any development software tools?) -- but the BDUs can get some
assistance from either of Speed Ferret from http://www.moshannon.com or
Find&Replace from http://www.rickworld.com, both of which will find each use
of a user-specified string anywhere in the database. I've used both in
previous versions, but haven't used the most recent versions of either one.
Larry Linson
Microsoft Access MVPs
"Richard" <ri************ @devenezia.comw rote in message
news:11******** *************@h 3g2000cwc.googl egroups.com...
What to do when the best laid plans change and mazes of legacy are
abolished, simplified, or built anew for contemporary reality.
A preliminary database was developed for tracking material through a
variety of manufacturing procedures. For a variety of business and
reality check reasons, the names of tables and columns need to be
changed, and some previously monolithic data tables are to be further
normalized.
What are some of the best tools for tracking down the complete side
effects of changing a relationship or changing the name of a table,
column, view, form, report, etc... The perfect tool would detect
dynamically generated queries used during event handling, and data
usages as directed by meta-data stored in control tables.
TIA,
Richard
"Larry Linson" <bo*****@localh ost.notwrote in
news:8EOwh.1273 6$WI6.8726@trnd dc04:
And, as Tom said, BDUs will be required for the more complex tasks
you specify (just for my information, is there software that will
do what you request for any development software tools?) -- but
the BDUs can get some assistance from either of Speed Ferret from
http://www.moshannon.com or Find&Replace from
http://www.rickworld.com, both of which will find each use of a
user-specified string anywhere in the database. I've used both in
previous versions, but haven't used the most recent versions of
either one.
Speed Ferret does seem to be moribund, since they have never
released an A2K3-specific version. Too bad.
It was an awfully good program.
I can't imagine that Name AutoCorrect has reduced their market,
since it JUST DOESN'T WORK.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
A significant part of SPEED Ferret was developed in VB6, so we've had
to rethink our development infrastructure and retool. It's been a
herculean effort. That's the main reason why this release is taking
longer than usual.
Fear not! SPEED Ferret 5 is coming, and it will support both Access
2003 and Access 2007.
Details and screen shots will be posted on www.moshannon.com in the
near future.
Bob Snyder
Black Moshannon Systems
On Feb 3, 12:23 pm, "David W. Fenton" <XXXuse...@dfen ton.com.invalid >
wrote:
"Larry Linson" <boun...@localh ost.notwrote innews:8EOwh.12 736$WI6.8726@tr nddc04:
Speed Ferret does seem to be moribund, since they have never
released an A2K3-specific version. Too bad.
It was an awfully good program.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
On 3 Feb 2007 13:30:38 -0800, "moshannon" <rs*****@moshan non.com>
wrote:
Rick Fisher is also working on an Access 2007 version of Find &
Replace.
-Tom.
>A significant part of SPEED Ferret was developed in VB6, so we've had
to rethink our development infrastructure and retool. It's been a
herculean effort. That's the main reason why this release is taking
longer than usual.
Fear not! SPEED Ferret 5 is coming, and it will support both Access
2003 and Access 2007.
Details and screen shots will be posted on www.moshannon.com in the
near future.
Bob Snyder
Black Moshannon Systems
On Feb 3, 12:23 pm, "David W. Fenton" <XXXuse...@dfen ton.com.invalid >
wrote:
>"Larry Linson" <boun...@localh ost.notwrote innews:8EOwh.12 736$WI6.8726@tr nddc04:
Speed Ferret does seem to be moribund, since they have never
released an A2K3-specific version. Too bad.
It was an awfully good program.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
On Feb 2, 5:09 pm, "Larry Linson" <boun...@localh ost.notwrote:
As far as I know, there is no "refactoringsof tware" for Microsoft Access.
One slight correction: This is not exactly a refactoring tool for
Access, but I have a refactoring tool for VB6, CodeShine
( www.codeshine.com), that you can use on VBA via cut-and-paste. It's
not exactly an ideal process, but I have found it worth doing on
occasion. If you want to use Extract Method on a VBA module, you can
create a new VB6 module, paste the entire VBA module's code into it,
refactor with CodeShine, and then paste the altered module back into
the Access project. It doesn't need to be compilable in VB6 in order
to be refactored, so you don't have to copy in any related modules or
set references.
Warren Sirota
"moshannon" <rs*****@moshan non.comwrote in
news:11******** **************@ a34g2000cwb.goo glegroups.com:
A significant part of SPEED Ferret was developed in VB6, so we've
had to rethink our development infrastructure and retool. It's
been a herculean effort. That's the main reason why this release
is taking longer than usual.
Fear not! SPEED Ferret 5 is coming, and it will support both
Access 2003 and Access 2007.
I'm so glad of that. I love Speed Ferret -- it does so much so
easily that it pays for itself the first time you use it. I was
really worried it wasn't going anywhere.
Why did you skip a 2003-only version, though?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
I think we got a little bit too optimistic about the schedule. In
hindsight, it is now clear that we should have added support for
Access 2003 and shipped a new version shortly after Access 2003 was
released. Instead we decided to make some significant structural
changes to the product as part of the same release. It seemed
reasonable at the time, especially since we initially received very
few requests for Access 2003 support.
The structural changes should have been delayed until after an Access
2003 release was shipped. Our mistake was in putting too many new
things into a single release.
We're proud of SPEED Ferret 5. We've worked hard to build a tool that
will pay for itself over and over by saving developers lots of time.
But we're also very sorry that we didn't ship an Access 2003 version
in a timely fashion.
Bob Snyder
Black Moshannon Systems
On Feb 4, 1:11 pm, "David W. Fenton" <XXXuse...@dfen ton.com.invalid >
wrote:
"moshannon" <rsny...@moshan non.comwrote innews:11****** *************** *@a34g2000cwb.g ooglegroups.com :
Why did you skip a 2003-only version, though?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"Warren" <ws*****@wsdesi gns.comwrote
On Feb 2, 5:09 pm, "Larry Linson" <boun...@localh ost.notwrote:
>As far as I know, there is no "refactoringsof tware" for Microsoft Access.
One slight correction: This is not exactly a refactoring tool for
Access, but I have a refactoring tool for VB6, CodeShine
(www.codeshine.com), that you can use on VBA via cut-and-paste. It's
not exactly an ideal process, but I have found it worth doing on
occasion. If you want to use Extract Method on a VBA module, you can
create a new VB6 module, paste the entire VBA module's code into it,
refactor with CodeShine, and then paste the altered module back into
the Access project. It doesn't need to be compilable in VB6 in order
to be refactored, so you don't have to copy in any related modules or
set references.
That's interesting. It would be more interesting, perhaps, if I had VB6
installed on the development machine I actually use -- I have it on an older
machine that I rarely use any longer, except for dealing with "older
versions". I don't often have a need for "refactorin g" in any case, as what
I develop is not "code intensive", generally. More often than not, my
snippets are only one or two lines (plus some error handling boilerplate),
or one logical construct, e.g. a SELECT CASE with a few cases.
I'll visit your site, though, and take a look. (I need to dig out the
keyboard and mouse pad on that old machine from under the paper I've
"temporaril y" stacked there, anyway.)
Larry Linson
Microsoft Access MVP This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: pmdanger |
last post by:
Hi,
I'm new in java and my customer want an application which works under
LINUX and WINDOWS plat forms.
So, i though logically in JAVA.
As i need to select my development tool, i would like to choose the
right one and not to throw money by windows...
|
by: Burkhard Perkens-Golomb |
last post by:
I'm looking for refactoring tools for C#. Any experiences and tips?
TIA,
Burkhard
--
Burkhard Perkens-Golomb mailto: burkhard.perkens-golomb@sdm.de
sd&m AG http://www.sdm.de
|
by: Kieran Benton |
last post by:
Hi everyone,
I'm just looking into this for my boss (and myself I suppose). What is the
current state of VB6 to VB.NET converters out there and what are they? I'm
trying to convince our company to convert its primary product over to .NET
but our primary project is pretty huge (many forms, lots of db work, lots of
CR9).
Any suggestions are helpful,
Thanks,
Kieran
|
by: DrUg13 |
last post by:
In java, this seems so easy. You need a new object
Object test = new Object() gives me exactly what I want.
could someone please help me understand the different ways to do the
same thing in C++. I find my self sometimes, trying
Object app = Object();
Object *app = Object();
Object app = new Object();
|
by: F. S |
last post by:
Would somebody please compare different C# development tools, such as MS
Visual Studio and Delphi 2005, C# and Delphi.net?
| | |
by: seberino |
last post by:
I'm trying to move beyond Emacs/Vim/Kate
and was wondering if Eclipse is better and if it is the *best*
IDE for Python.
Should I leave Emacs and do Python coding in Eclipse?
Chris
|
by: Simon Cooke |
last post by:
Does anyone know of any tools for refactoring header files?
We're using a third party codebase at work, and pretty much every file
includes a 50Mb precompiled header file. I'm looking for a tool that will
let us figure out which header files are actually needed by each .cpp, and
allow us to break this up so that we're not including the world in each one.
Ideally, the same tool would also recognize where #includes can be replaced
with...
|
by: burgermeister01 |
last post by:
First, let me say that this question is a rather general programming
question, but the context is PHP, so I figured this group would have
the most relevant insight.
Anyways, this is also more of an opinion based question than one
seeking a definite answer. Recently, while maintaining a rather large
system. I needed to add an array class member to an object. It was
exactly the same as another class member, except that one array stored...
|
by: mbrown |
last post by:
I'm fairly new to C, and newer to Linux. I currently do all of my
development on a windows machine using Visual Studio, then use Make to
build the code on Linux. Obviously this deprives me of a lot of
debugging tools. I'm also used to having a variety of tools for
refactoring and unit testing, but these aren't concepts that are
familiar at my company.
Any advice on good tools for refactoring and unit testing C code, and
for debugging on...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
