Re: Find and Replace in the Whole Base

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"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
http://mvp.support.microsoft.com/

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

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

"Telesphore" <tgNoSpam@xxxxxxxxxxxxxxxx> wrote in message
news:ezGg6IFOHHA.1872@xxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Data Retrieval/Insertion Data Structure
    ... On Fri, 2 Jul 2004, John Harrison wrote: ... >> duplicate records with the same value, ... >> should be efficient to insert the records into the data structure. ... >> there any database structure that I can get help with ?? ...
    (comp.lang.cpp)
  • Re: Data Retrieval/Insertion Data Structure
    ... > should be efficient to insert the records into the data structure. ... > there any database structure that I can get help with ?? ... trouble fitting 1000000+ records into any data structure. ...
    (comp.lang.cpp)