The code below should do what you want. ------------------------------------------------------------------ DISCONNECT SET MULTI OFF CONNECT T_TIR PACK DISCONNECT SET MULTI ON CONNECT T_TIR -------------------------------------------------------------- Good Luck, Manuel "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
begin:vcard n:de Aguiar;Manuel tel;fax:(323)661-7698 tel;work:(323)660-3511 x-mozilla-html:FALSE url:http://www.mdenterprises.net org:M|D Enterprises adr:;;2412 No. Commonwealth Avenue;Los Angeles;California;90027-1206;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Developer note;quoted-printable:The information contained in this e-mail may be privileged, confidential,=0D=0Aand protected from disclosure. If you are not the intended recipient, you=0D=0Aare hereby notified that any dissemination, distribution or duplication of=0D=0Athis communication is strictly prohibited. If you have received this=0D=0Acommunication in error, please notify the sender immediately and delete all=0D=0Acopies.=0D=0A=0D=0Ahttp://www.mdenterprises.net=0D=0Ahttp:/www.databasedeveloper.com=0D=0Ahttp://www.MdrBASE.com=0D=0A x-mozilla-cpt:;-1 end:vcard
