>I am trying to remove the records in a database by browseing the table and then slecting Table/Remove deleted records.
>
>I get this TABLE MUST BE OPENED EXCLUSIVELY. Is there something that I should be aware of? I am trying to write code where I can delete all of the records in the table by clicking a button, not simply marking them for deletion.
>
>MS Access is so much easier, I am banging my head at how slow development is when you are first trying to learn this program.
IF you're just deleting the records (marking them as deleted, like with the DELETE command) then you do not need exclusive use. If you want to remove all the deleted records then you have to do a pack....which means you need exclusive use of the table.
SET EXCLUSIVE ON
USE MYTABLENAME
PACK
ICQ 10556 (ya), 254117