Modifying database tables after Splitting

[Vince]

Is it possible to redirect my queries, forms, reports, etc
in my front-end database to any RENAMED tables in my back-
end database?

I ask the above question because this is my story:

A few weeks back, I created a barebones, one table
database, gave it a query and a form to interface with it,
then split the database anticipating further development.
I tested it out and was pleased, albeit a simplistic test,
but pleased nonetheless

Recently I modified this table, re-named it in
anticipation of adding other tables to it, then saved the
datbase.

However, after attempting to open the sole form in the
front end database, I got an error saying it couldn't find
the table.

I'd hate to think that for any change I make to the
tables, I would need to delete the old interfaces to it
and re-create them.

Thank you in advance for anyone who can at least shed a
light on my problem, and I hope this is somewhat coherent.

Vince

 

[Cheryl Fischer]

If you have any VBA code in your form that refers to your renamed table, you
can do a Find|Replace fairly easily, but other object references such as
those found in a Query, will need to be changed manually.

When object name changes are made in a large project, there are third-party
tools that will do the job:

Total Access Analyzer
http://www.fmsinc.com/Products/analyzer/index.html

Speed Ferret
http://www.blackmoshannon.com

 

[Albert D. Kallal]

Is it possible to redirect my queries, forms, reports, etc
in my front-end database to any RENAMED tables in my back-
end database?

The fact is, even if your database is NOT split, if you re-name a table,
then all code, reports, forms that reference that table name will also have
to hunted down and also changed. So, your problem HAS ABSOLUTE NOTHING to do
with the fact that you split. I suppose you *might* be using auto-correct.
And autocorrect does try and fix everything..but it does not work for split
mdb's, and further the first thing that any developer of any experience does
is turn off auto correct!

However, after attempting to open the sole form in the
front end database, I got an error saying it couldn't find
the table.

Yes, perhaps every pc in the building should also change it's table name
also? How can all these pieces of software talk to each other and know about
his change? Gee, perhaps maybe when you re-name a table on your pc, some
tables on my pc will get renamed?

I'd hate to think that for any change I make to the
tables, I would need to delete the old interfaces to it
and re-create them.

You can most certainly modify a table design, you can add new fields, you
can add new relationships, you can add new indexes etc. However, you
certainly cannot re-name a table name, and expect all kinds of code and
other files on your computer or files around the world on other computers to
magically change. I hate to think that computers would work this way!

So, you can modify the designs of the tables, you can add new fields to the
tables, you can even add new tables to the database. However, if you re-name
a table, then ALL CODE and references to that table MUST also be re-named.
As a result of this...you can't effectively change table names after you
start development without some serous work resulting in this change.

The exact same problem exists with field names. If you change the name of a
field, then all programs in the building, or programs around the world that
use that database will have to be changed also.

 

[Guest]

Cheryl,

Thank you for responding with a concise answer to my
problem, and a reference to a possible tool to use. I
appreciate that.

Vince.

 

[Guest]

I appreciate you taking the time to answer my question,
but I could have done without the condescending tone.

Vince.