deleting tables

[Guest]

How do i delete a table in my access 2003 database? i'm in the tables tab of
the objects (where it has create use DW, using w, and Ent Data) however the
red X for deleting is greyed out.

it's on all of my databases. what's worng?

 

[Granny Spitz via AccessMonster.com]

How do i delete a table in my access 2003 database? i'm in the tables tab of
the objects (where it has create use DW, using w, and Ent Data) however the
red X for deleting is greyed out.

Click on the table you want to delete so it is highlighted. Press the
<DELETE> key.

 

[Guest]

well, i know with start with the obvious. I tried the <Delete> key, and that
didn't work. i cna't do a Cut either

 

[Granny Spitz via AccessMonster.com]

well, i know with start with the obvious. I tried the <Delete> key, and that
didn't work. i cna't do a Cut either

Ok. It was worth a try. Was this database opened as read-only? Is it an
"enabled" database, one that is in an earlier database format and hasn't been
converted to the current version you opened it with? In both cases, you
won't be able to make changes to the file like deleting objects.

 

[Guest]

I think i got it. I wasa running a few applictions, including a remote
desktop to a NAS server. the NAS was doing a backup procedure, and must have
taken over my memory, because i couldn't copy/paste anywhere. i closed that
and restarted, and all is finenow. i guess looking for thte memory usage
wouldn't be on the top of the list. i gather that access "saves" any data it
deletes incase something goes wrong. true?

thanks for the help!

 

[Granny Spitz via AccessMonster.com]

i guess looking for thte memory usage
wouldn't be on the top of the list.

It wasn't on mine either!

i gather that access "saves" any data it
deletes incase something goes wrong. true?

No, Jet marks it for deletion but doesn't remove it from the file until it

thanks for the help!

You're welcome, Mike.

 

[Bill Mosca, MS Access MVP]

Mike

Access saves data up to a point, but don't count on it when deleting an
object. Usually, once it is gone, it is really gone.

In the case of a table, you can back out the delete if you run some recovery
code right away. It must be done before you delete another object or close
the database as it uses data in a buffer.

You can get the code to recover a deleted table here:
http://www.databasejournal.com/features/msaccess/article.php/1494111