PDA

View Full Version : Pack command in ASP MS Access

luigicannavaro
08-15-2008, 10:22 PM
Hi,

Please, do you know how "eliminate" all records of a table written in MSAccess, but not DELETE IT! In Other databases like FoxPro, Clipper, etc. there is a command named PACK. But I donīt know any similar function or command in MSACCESS/ASP 3.0

Thank you

Luigi
SSJ
08-18-2008, 09:12 AM
What do you mean by eliminate over here?
oesxyl
08-18-2008, 12:11 PM
What do you mean by eliminate over here?
can you please focus on a decent answer more then on adevertising?
op question seams very clear, so if you know any replacement for pack, just answer.

best regards
SSJ
08-19-2008, 12:14 PM
can you please focus on a decent answer more then on adevertising?
op question seams very clear, so if you know any replacement for pack, just answer.

best regards
Mate I am not knowing what the PACK is but I can have answer for any ASP question.
oesxyl
08-19-2008, 12:32 PM
Mate I am not knowing what the PACK is but I can have answer for any ASP question.

http://msdn.microsoft.com/en-us/library/t2704cs4(VS.80).aspx

I think you know what I mean.

regards
Spudhead
08-19-2008, 12:39 PM
I'm not familiar at all with FoxPro, but I'm struggling to see how PACK (http://msdn.microsoft.com/en-us/library/t2704cs4(VS.80).aspx) differs from DELETE. :confused:

If you delete all unwanted records from your Access database and then repair it (Tools -> Repair Database, I think, it's been a while since I did anything in Access) that should have pretty much the same effect: remove the records and reduce the database filesize accordingly.
oesxyl
08-19-2008, 12:49 PM
I'm not familiar at all with FoxPro, but I'm struggling to see how PACK (http://msdn.microsoft.com/en-us/library/t2704cs4(VS.80).aspx) differs from DELETE. :confused:

If you delete all unwanted records from your Access database and then repair it (Tools -> Repair Database, I think, it's been a while since I did anything in Access) that should have pretty much the same effect: remove the records and reduce the database filesize accordingly.
I have no idea about access and asp. In foxpro and clipper, delete only mark the rows as deleted and must use pack to phisicaly remove them.

best regards