deleting tables, queries, etc

D

DogmaDot

I have a cluttered MDB. I created a group and moved tables I wished to
delete into it. Clicked on the new group name, all that I had flagged to
remove were there. Right clicked on the group name, picked delete, but none
of them went away. Am I doing something wrong?

I am using 2003 professional
 
J

John Spencer

You are mistaken on what a group is.

A group is basically a collection of aliases to the actual objects. When you
delete the group you delete the collection of aliases - you don't delete the
objects that the aliases point to.

You will have to delete the objects (tables) individually from the tables
collection. Before doing so, I assume that you have made a backup just in
case you make an error and accidentally delete a table you need.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
D

DogmaDot

Thanks. I guess I misread the help column.

Dot

John Spencer said:
You are mistaken on what a group is.

A group is basically a collection of aliases to the actual objects. When you
delete the group you delete the collection of aliases - you don't delete the
objects that the aliases point to.

You will have to delete the objects (tables) individually from the tables
collection. Before doing so, I assume that you have made a backup just in
case you make an error and accidentally delete a table you need.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
 
Top