Hi Phil,
Here are the basic steps.
1. Disconnect
2. Set Multi off
3. connect
4. pack
5. disconnect
6. set multi on
7. connect.
I do not recommend pack, do a reload to a sub directory (ie back), then if
reload is good, copy from back
reload steps.
1. md back
2. Disconnect
3. Set Multi off
4. connect
5. reload back\dbname
6. disconnect
7. copy back
8. set multi on
9. connect.
Ben Johansen - www.pcforge.com
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 11:47 AM
> To: Rbase-L
> Subject: Pack in place
>
> 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
winmail.dat
