Phil
First you have to
DISCONNECT
SET MULTI OFF
CONNECT dbname
do your pack
DISCONNECT
SET MULTI ON
Jim Limburg
"Phil Nolette (NCS Group, Inc.)" wrote:
>
> I know that it is written someplace but I need to do it fast.
> I just deleted 1500 rows of test incident reports from a T_TIR table. I
> checked the database and there are no errors. I did a backup and am now
> ready to optimize the table by doing a pack in place - all. When I try it,
> it says that I must be in a single user mode. I looked at settings and it
> is grayed out. How do you put the database in a single user mode and then
> after I do the pack in place, set it back to multi-user.
> Thanks,
> Phil Nolette
>
> ------------------------------------------------------------------------
> Name: winmail.dat
> winmail.dat Type: DAT File (application/x-unknown-content-type-DAT_auto_file)
> Encoding: base64
