Jumat, 12 Februari 2016

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 (4)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar