How can I find out where a table is being used in my access db?
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) |
|