Re: How can I find out where a table is being used in my access db?



On 15 Aug 2006 02:04:35 -0700, mj.redfox.mj@xxxxxxxxx wrote:

Use a utility like Speed Ferret or Find & Replace.

-Tom.


Does anyone know if there's any way I can find out where, in my
database, a specific table is used or referenced?

I'm wanting to clear out a few linked tables, but need to be sure I've
removed all references to it in things like forms, queries etc - I'm
pretty sure I have done, but it would be reassuring if I could somehow
obtain an overall 'snapshot' view of any occurrences of it within the
database as a whole.

.



Relevant Pages

  • Re: DB Architecture Questions (for joe celko)
    ... So a deck of punch cards or a mag tape is just like an SQL Schema to ... a table has a name in the database. ... OCCURS clause. ... This rule would be enforce by a REFERENCES clause on the Orders table ...
    (microsoft.public.sqlserver.programming)
  • Re: Table Design Question
    ... > requires more than two probes, no matter how large the database. ... > acceptable (in the relational model) to have an Identity attribute to ... the gap in the sequence is not filled in and the sequence ... > vin CHARNOT NULL REFERENCES Motorpool); ...
    (microsoft.public.sqlserver.programming)
  • Re: Mixed up with Relationships..help!
    ... The database you're describing ... The CONSTRAINT statement establishes a Primary Key or a Foreign Key, ... "REFERENCES" table and column. ... QuestionaireAnswers: QuestionaireAnswersID, StudentID, 2005, ...
    (microsoft.public.access.gettingstarted)
  • Re: One PC not able to calculate formulas
    ... Are you using ONE database on a server that everyone is accessing? ... If you get no errors then select Tools: References ... Then check the reference libraries on that computer. ... If any of the selected references have "MISSING:" in front of them, unselect ...
    (microsoft.public.access.gettingstarted)
  • Re: Newbie question on table design.
    ... The early SQL systems were also ... built on a queues and locking model because that is what we had. ... a row is defined in the database ... REFERENCES clause on the Orders table which references the Inventory ...
    (comp.databases.theory)