Jumat, 12 Februari 2016

Re: [MS_AccessPros] Table Name

 

Hi Bill,

if you just have one table, use V-Tools Deep Search on the front-end to change where it is referenced.

Obviously, if fields have been removed, then you can't change their names with a tool and will have to test your queries.

You could run  code on your database, maybe before and after you change names, to document queries to Word.

Document Query SQL, Form and Report RecordSources
http://www.rogersaccesslibrary.com/forum/document-query-sql-form-and-report-recordsources_topic606.html
Create Word documents with SQL for queries, form and report RecordSources, and make a query showing database objects

warm regards,
crystal

~ have an awesome day ~

On 2/12/2016 12:39 PM, 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] wrote:

My table is not that big.  1200 records.  15 fields.  It is used in 5 queries in the FE

 

What will happen to the queries if I change the name?  Will I have to create the queries all over again?  Will the tables disappear out of the queries with all the field now gone?  If the old table stays in the query but just goes to error I can fix it one field at a time.

 

Bill

 

  

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 12, 2016 1:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Table Name

 

 

and depending on how big the tables are, it might make better sense to put FE objects into the BE

whichever you use, if you do, make sure AutoCorrect is off

Microsoft Access Flaws - Failures caused by Name Auto-Correct, by Allen Browne
http://allenbrowne.com/bug-03.html

if you haven't turned it off, then it is on

in 2007:

1. Click the Microsoft Office Button Button in the upper left corner
2. choose --> Access Options (lower right corner)

in 2010, 2013:

1. File ribbon menu
2. Options (near bottom)

~~~

then:

3. Current Database from left sidebar


in Access 2000 - 2003:
1,2,3. from the menu --> Tools >> Options >> General

-----------------------------------
THEN:
4. Under Name AutoCorrect Options:
uncheck --> Perform Name AutoCorrect
5. Compact/Repair
6. then go back and uncheck --> Track Name AutoCorrect info
7. Compact/Repair again

warm regards,
crystal

~ have an awesome day ~

On 2/12/2016 12:14 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

oops! I meant V-Tools ... that is the free one

V-Tools freeware
http://www.skrol29.com/us/vtools.php

-- not really paying attention, working on something else

On 2/12/2016 12:11 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

Hi Bill,

perhaps temporarily delete links and import the back-end tables into the development FE and use something like MZ Tools Deep Search and replace.  It used to be free but now there is a small price.

http://www.mztools.com/

warm regards,
crystal

~ have an awesome day ~

On 2/12/2016 9:37 AM, 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] wrote:

I have a split database.  I am in the ongoing effort of correcting and standardizing my naming convention. 

 

Is there any way to change the name of a table in the BE and have it automatically go to the front end.  I just want to avoid fixing all the queries.

 

 

 

Bill

Minnesota

 

 

 


__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar