[R-sig-DB] Using RODBC with Access open

[Geraets, David]

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>