Delete column data (Access 97)

[NervousRex]

I need help creating a SQL statement to delete all the data in a certain column.

The column is BeginDate and the table is Billing Troubleshooting.



Thanks!

 

[Golom]

UPDATE [Billing Troubleshooting] Set [BeginDate] = NULL

 

[NervousRex]

Thanks

Might be a minute too late though.


I just totally wiped the whole table. I had made a copy of the db to test with, but they stayed linked....so el deleto in copy did the el deleto in production.


waiting for system admin to see what he can recover....hopefully its my job

 

[NervousRex]

so while i'm waiting to see if i'll be here the rest of the day or not...


how do you unlink the main database and a copied version?

 

[Golom]

Step 1: Delete the linked table from the mdb that has it as a link. This doesn't delete the table, it just removes the link.

Step 2: Select New Table / Import Table and then select the database and table(s) that you want to import. That puts a copy of the table in your database that is independent of the same table in the source mdb.

Assuming that all this isn't just academic knowledge ... maybe you can use it in your next job.