Can anyone suggest how I might be able to "pack" a linked DBIII file from
within access. I am using access to build the data needed for a label
printer (it can only read DBIII) and currently have to open the printer
utility to pack the database to remove the deleted records. I would like to
eliminate this step by including something that can be called from access
that will look after this. Any suggestions or direction would be
apprecitated!
Pack a linked DB file ... Can anyone suggest how I might be able to "pack" a linked DBIII file from ... utility to pack the database to remove the deleted records.... (microsoft.public.access.externaldata)
Re: PACK question ... the reason no temp files were created is that there were no ... This time I used the command "PACK MEMO".... and 2)if there are no deleted records, PACK will not create any temporary ... > VFP will use the current directory for storing the output of PACK, ... (microsoft.public.fox.programmer.exchange)
Re: Pack a linked DB file ... I am a bit confused - how does the dBase file get created? ... If Access creates it then just don't include deleted records.... Doesn't that program have a Pack command in it? ... > DB in the label program and packing it before we print. ... (microsoft.public.access.externaldata)
Re: OLE DB from .NET/open & close connections ... it's a bad idea to pack the table after each single ... Say rewrite 999.999 out of a million ...deleted records or not: SET DELETED ON/OFF. ... into an object as fast as FOPEN and positioning... (microsoft.public.fox.programmer.exchange)