Rod-
If you're using 2007 or later, switch to "Tables and Related Views" in the
Navigation pane to see which queries, forms, and reports are dependent on which
tables. If you remove a table, simply remove all the dependent other objects
first. As for removing columns, I would leave them alone in the tables and just
remove them from forms and reports where I don't need them.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of borninfulton
Sent: Tuesday, August 28, 2012 4:29 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Looking for a template for documenting my trouble
shooting tips
Hi John,
Thank you for your response. I'm concerned, though, if I remove columns or
tables that don't cover what I need, and some Access forms have been developed
using either those columns or tables, that it would result in problems.
Still, I guess I could just live with that.
Rod
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Rod-
>
> If templates like "problem tracking" or "issues tracking" do everything that
you
> want but are more than you need, it would seem to be a good idea to start with
> one of those and then just take away or disable stuff you don't need to use.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
<snip />
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar