Find and Replace in the Whole Base

[Telesphore]

We simplified table A by creating table B.

We transferred 50 fields from table A to table B.

We removed these 50 fields from table A.

Is there a fast way to correct the original names of the fields in the
queries and forms of the base? For example, how to replace in the base all
occurrences of tblA.Student by tblB.Student?

Thank you

 

[John Vinson]

We simplified table A by creating table B.

We transferred 50 fields from table A to table B.

We removed these 50 fields from table A.

Is there a fast way to correct the original names of the fields in the
queries and forms of the base? For example, how to replace in the base all
occurrences of tblA.Student by tblB.Student?

Thank you

There's the buggy and unreliable Name Autocorrect (aka Name
Autocorrupt) in Access 2002 and later; or there are some good third
party tools:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

John W. Vinson[MVP]

 

[Jeff Boyce]

"Simplify" is not one of the standard normalizing reasons I've run across
for changing a database structure. If you'll provide a bit more description
about your data structure, the newsgroup readers may be able to offer
suggestions that will give you greater use of Access' features/functions.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Telesphore]

Thank you,

I tried the first two links, but it seems there is problem with those two
characters: É and ô

 

[Telesphore]

Thank you,

What I mean by "Simplify" is that we realized that some fields in the table
tblÉtudiants should be better in creating a new table tblDiplômes, for
example the fields: MentionBPh, BPhNoteTrvÉcrit, MatriculeBPhLatran,
DateBPhObtention, and so on.

 

[John Vinson]

Thank you,

I tried the first two links, but it seems there is problem with those two
characters: É and ô

Perhaps if you could explain the nature of the problem, someone could
help.

John W. Vinson[MVP]

 

[Telesphore]

Thank you,

We realized that some fields in the table "tblÉtudiants" should be
trasnfered in the newly created table "tblDiplômes", for example the fields:
MentionBPh, BPhNoteTrvÉcrit, MatriculeBPhLatran, DateBPhObtention, and so
on.

For example with "Find and Replace" in queries and forms of the base, I
asked to find "tblÉtudiants.DateBPhObtention" and replace it by
"tblDiplômes.BateBPhObtention"

 

[Jeff Boyce]

Thanks for the clarification. However, unless we know what kind of
information is being stored in these fields, and what the underlying
entity-relationship model is, that probably won't be quite enough of an
explanation. (Sorry, I don't understand ?French well enough to guess what
might be in these fields.)

I asked my question because it is rare to need to "move" fields in a
well-normalized database. Is this part of the process of normalizing your
database?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[John Vinson]

Thank you,

We realized that some fields in the table "tblÉtudiants" should be
trasnfered in the newly created table "tblDiplômes", for example the fields:
MentionBPh, BPhNoteTrvÉcrit, MatriculeBPhLatran, DateBPhObtention, and so
on.

For example with "Find and Replace" in queries and forms of the base, I
asked to find "tblÉtudiants.DateBPhObtention" and replace it by
"tblDiplômes.BateBPhObtention"

And what problem did you have?

John W. Vinson[MVP]

 

[Telesphore]

There is a table tblStudents(=tblÉtudiants) in which there are fields that
could be transfered to a new table that we would like to call tblDiplomas
(=tbl Diplômes). All the fields related to grades obtained by the students,
for example the marks "A+" , "B", "C-"... in the field "TermPaperMarkBAPh"
(=BPhNoteTrvÉcrit) the marks for the term paper for his B.A. in Philosophy.

I suppose that the creation of a new table is a kind of normalization of a
data base.

I tried "MDBSearch" from
http://www3.bc.sympatico.ca/starthere/findandreplace and "Replace9" from
http://www.rickworld.com but it did not work.

 

[Telesphore]

I tried "MDBSearch" from
http://www3.bc.sympatico.ca/starthere/findandreplace and "Replace9" from
http://www.rickworld.com but it did not work.

 

[John Vinson]

I tried "MDBSearch" from
http://www3.bc.sympatico.ca/starthere/findandreplace and "Replace9" from
http://www.rickworld.com but it did not work.

"Doctor, I don't feel good, what should I take?"

What didn't work? What did you try? What errors did you get; what
result did you get that you didn't want?

John W. Vinson[MVP]

 

[Jeff Boyce]

If you have a field that is named after a specific student (?Mark?) and
after a specific activity ("TermPaper") and concerning a specific degree
program ("BA in Philosophy"), your table is NOT normalized. You have a
spreadsheet if the above is true, not a relational database table.

If the above IS true, spend some time looking into normalization and
database design before you do anything else:

http://home.bendbroadband.com/conradsystems/accessjunkie.html

If you don't, you will struggle to get Access to do simple things that it
can easily do, but only with well-structured data.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Telesphore]

Thank you for the links, very useful.

BTW "Mark" is not a student's name but a field for the results of the work
of the students in the database.