If I am deleting a table, is there any way to tell if it has been used in a
query before I delete it?

If you right click the table and select "Object Dependencies", it will give
you a view of all other objects (forms, queries, reports, etc) within your
db that use that particular table.
"kayabob" <(E-Mail Removed)> wrote in message
news:31261242-3478-4606-A143-(E-Mail Removed)...
> If I am deleting a table, is there any way to tell if it has been used in
> a
> query before I delete it?

perfect, thank you.

"Elaine" wrote:

> If you right click the table and select "Object Dependencies", it will give
> you a view of all other objects (forms, queries, reports, etc) within your
> db that use that particular table.
> "kayabob" <(E-Mail Removed)> wrote in message
> news:31261242-3478-4606-A143-(E-Mail Removed)...
> > If I am deleting a table, is there any way to tell if it has been used in
> > a
> > query before I delete it?
>
>
>

Is that version-specific? I'm running 2002 and do not see that as a selection.

"Elaine" wrote:

> If you right click the table and select "Object Dependencies", it will give
> you a view of all other objects (forms, queries, reports, etc) within your
> db that use that particular table.
> "kayabob" <(E-Mail Removed)> wrote in message
> news:31261242-3478-4606-A143-(E-Mail Removed)...
> > If I am deleting a table, is there any way to tell if it has been used in
> > a
> > query before I delete it?
>
>
>

> Is that version-specific? I'm running 2002 and do not see that as a
> selection.

Yes only Access 2003 (currently) has it.

The downside is that to use Object Dependencies you also have to have Track
Name AutoCorrect enabled.

If anyone with Access 2003 wants to use Object Dependencies and has Track
Name AutoCorrect disabled you can make a copy of your MDB and enable
AutoCorrect and run Object Dependencies and then use the information to work
on your "good" MDB.

Track Name AutoCorrect is generally considered to be buggy and can make
Access unstable and _s l o w_, along with Lookup Fields and Subdatasheets
which are all best avoided.

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
"Jeff Schneider" <(E-Mail Removed)> wrote in message
news:36960B3D-9237-4A80-95F4-(E-Mail Removed)...
>
> "Elaine" wrote:
>
>> If you right click the table and select "Object Dependencies", it will
>> give
>> you a view of all other objects (forms, queries, reports, etc) within
>> your
>> db that use that particular table.
>> "kayabob" <(E-Mail Removed)> wrote in message
>> news:31261242-3478-4606-A143-(E-Mail Removed)...
>> > If I am deleting a table, is there any way to tell if it has been used
>> > in
>> > a
>> > query before I delete it?
>>
>>
>>