[R-sig-DB] Using RODBC with Access open
Geraets, David
D@v|d@Ger@et@ @end|ng |rom w|v-|@p@be
Mon May 17 15:22:59 CEST 2010
I all,
I face a strange behaviour, using RODBC - SQLSave to save a table into an Access Database :
- If the Access database is closed, the (initially empty) database increases to a size of 55 MB.
- If the database is open during the "Save" operation, it increases to a size of around 900 MB, which I can reduce to 55 if I compress/repair the database.
Does anyone know what's happening ? (is it linked to some sort of rights problem ? do I have a way to connect to the database that might change this, or a parameter in the SQLSave function ?)
(my interest in keeping the database open is due to the fact that I call R from an access VBA, using the RDCom tool)
Thanks in advance,
David
[cid:image001.gif using 01CAF5D4.D55FD5E0] DAVID GERAETS, PhD
Epidémiologie
Rue Juliette Wytsmanstraat 14 | 1050 Brussels
T 02 642 50 26 | F 02 642 54 10
Institut Scientifique de Santé Publique
Wetenschappelijk Instituut Volksgezondheid
Scientific Institute of Public Health
www.wiv-isp.be<http://www.wiv-isp.be>
###########################################################
Checked as being free of known viruses.
Scientific Institute of Public Health, Brussels, Belgium
Wetenschappelijk Instituut Volksgezondheid, Brussel, België
Institut scientifique de Santé publique, Bruxelles, Belgique
Visit our website: http://www.wiv-isp.be
###########################################################
DISCLAIMER: Please see http://www.wiv-isp.be/Disclaimer.asp
###########################################################
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://stat.ethz.ch/pipermail/r-sig-db/attachments/20100517/bd7c8166/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 1173 bytes
Desc: image001.gif
URL: <https://stat.ethz.ch/pipermail/r-sig-db/attachments/20100517/bd7c8166/attachment.gif>
More information about the R-sig-DB
mailing list