Question about TAdoDataSource

[franksoft]

I am using TAdoDataSorce TSQLTable, to access data.accdb everything works fine.
The size increases data.accdb if I add records or if I enter data in fields object/OLE, but the size of data.accdb, not decreases it if I delete records or delete data object/OLE.
Using MS Access 2007 database to compact the data.accdb is resized.
You can compact with Xailer?
frank

[ignacio]

franksoft escribió el mar, 21 febrero 2012 19:39I am using TAdoDataSorce TSQLTable, to access data.accdb everything works fine.
The size increases data.accdb if I add records or if I enter data in fields object/OLE, but the size of data.accdb, not decreases it if I delete records or delete data object/OLE.
Using MS Access 2007 database to compact the data.accdb is resized.
You can compact with Xailer?
frank
Frank,
Try with oAdoDataSource:Execute( "CompactDatabase" )
-OR-
oAdoDataSource:oRecords:oAdo:CompactDatabase()
If none of the above work, then take a look at this link:
http://support.microsoft.com/kb/295334/en-us?fr=1
Regards,

[franksoft]

Ignacio,
oAdoDataSource:Execute( "CompactDatabase" )
generates attachment erroreSQL1
oAdoDataSource:oRecords:oAdo:CompactDatabase()
generates attachment erroreSQL2
While Jetcomp.exe is not compatible with file.accdb extension and do not think it can be used at runtime
thanks for the suggestions
Frank

Attached files