Monitor identify AutoCorrect data When this option is chosen, Access retains track of item name improvements while in the databases. The tracking information is stored in identify maps. Once you help this feature for The 1st time, Accessibility results in a reputation map for each of the present databases objects.
Conduct identify AutoCorrect When this selection is chosen, Obtain automatically fixes name changes since they manifest. You are able to pick this feature only if the Monitor name AutoCorrect information alternative is previously chosen.
Clear the Track name AutoCorrect information Check out box, and afterwards simply click Alright. Obtain will alert you that every one open up databases objects need to be shut for that transform to choose outcome.
When you work in a very database that includes a layout that's frequently adjusted by customers, databases objects can quit Doing the job if the design of other databases objects modifications.
Building name maps usually takes a number of minutes. You could push ESC to cancel this phase. However, the title maps of some objects are going to be outdated, and you will not have the capacity to see the dependency facts for those objects right up until the identify maps are current.
One example is, for those who make a query that is based on a desk named Shoppers, as well as the name of the desk is later on altered to Consumer, the question you designed stops Functioning because of this identify modify.
When you're employed in the databases that features a style and design that may be frequently changed by customers, database objects can stop Operating if the look of other databases objects improvements.
Relates to: Obtain 2007 Additional... Much less Title AutoCorrect is often a feature that helps hold the operation within your databases from breaking when its style is usually adjusted, particularly when several customers make unplanned design and style alterations.
You intend to make your database file lesser, and they are ready to click here control object identify improvements manually When title AutoCorrect is enabled to get a databases, you would possibly observe an increase in the databases measurement.
The name map stays up-to-day given that this selection stays selected. Name maps are utilized to take care of glitches that happen to be a result of renaming, and also to create item dependency information and facts. Title maps cannot be accessed directly.
Clear the Keep track of title AutoCorrect info Look at box, and afterwards click on Alright. Entry will warn you that all open up database objects needs to be closed for the transform to get effect.
This increase is attributable towards the name maps that identify AutoCorrect makes when it can be enabled. For those who disable title AutoCorrect, title maps are eliminated, which minimizes the size of your databases.
Generating name maps usually takes numerous minutes. You could press ESC to terminate this step. On the other hand, the name maps of some objects is going to be out-of-date, and you will not have the capacity click here to see the dependency facts for all those objects until eventually the identify maps are updated.
Observe: In case you interrupt Accessibility (by urgent ESC) when it can be updating the title maps, Obtain won't disable the Observe name AutoCorrect details selection. The Monitor identify AutoCorrect data choice continues to be chosen, even though the title maps have not all been up-to-date. To restart the process of updating title maps, use this process: