Quote:
|
Originally Posted by endgame
If I discover an error or want to make a change, e.g. Find that in 2008 I listed the wrong manager for a team -- can I use Access to simply go in there and make that change -- run new htmls -- and be done with it?
Is there any risk of harm simply opening the file with Access and then closing it if I decide not to make any changes? I know it sounds simple, but I get a little sc-sc-sc-scared to mess with my database.
Is the area you want to change even remotely easy to find?
|
There is no harm in opening the database and closing. The only harm would be to open and make edits and not fully understand what you are doing. You wouldn't want to edit say a primary or secondary key unless you really knew the impact and knew which other related tables would need to be modified. Having said that, I can't imagine a scenario where editing a key field would be required.
You can go in and change manager names and just run the HTML again. However, for manager the CATO UI has a nice tool that let you edit them for any season and lets you copy over fields from a previous season. If editing a manager name is what you are after, look at the UI first, the tool is very easy to use.
Its relatively easy to make your way through the CATO schema.