Private project for Krusche: Fix database size increase issue

The job which converts the onix/xml update files unnecessarily increases the database size when an update file is imported.

The increase is mysterious and far larger than the size of the update file: An XML file with the size of 10mb and about 2.500 records results in an increase of 500mb in the Access file. Meaning that if we process 3 XML files, Access crashes because it reaches the physical limit of 2gb.

We have done some Googling on the possible cause for the bloating and it seems that it can be prevented by calling queries and/or objects in a different way. For example: [url removed, login to view]

So my request is to adapt the job in such a way that size-efficiency is accounted for.

My request is to have the new version of the job ready on January 4th, or, if that is not possible, let me know a committed date in the week after.

NB. we have made some changes in the job-code in the past period! So I attach the latest version of the code for you to use.

Kemahiran: Microsoft Access, XML

Lihat lagi: nb com, calling for a job, onix, fix database, fix database access, access 2010 project, access database process, access onix, access 2010 example database, code attach database, microsoft access 2010, googling, microsoft access version, adapt xml, private job com, access physical files, onix files, converts xml, microsoft project 2010, onix xml access, physical access, private version, access date update, access code project, access 2010 database

Tentang Majikan:
( 4 ulasan ) Weesp, Netherlands

ID Projek: #4062212

Dianugerahkan kepada:


As discussed.

€30 EUR dalam 7 hari
(7 Ulasan)

7 pekerja bebas membida secara purata €116 untuk pekerjaan ini


Please check PMB for more detaiils. Thanks

€250 EUR dalam 10 hari
(51 Ulasan)

Hi, The reason for the size increase is that the storage space is not being re-claimed after processing of the data is completed. To reclaim the disk space a compact-repair of the database is needed. This can be ac Lagi

€45 EUR dalam 3 hari
(10 Ulasan)

Dear Sir, I'm Expert on access. Best Regards, NourElDeen

€50 EUR dalam 3 hari
(18 Ulasan)

Hi, understood the requirement ready to start. Thanks.

€50 EUR dalam 5 hari
(0 Ulasan)

I am ready to deliver in 5 days. pls check PM & confirm.

€200 EUR dalam 5 hari
(0 Ulasan)

Records can be imported in [url removed, login to view] provide the project

€30 EUR dalam 5 hari
(0 Ulasan)

hi I have ten years experience on MS Access. I have done seven Access DB for client in 2012 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Btw: I were MVP about Micr Lagi

€200 EUR dalam 5 hari
(0 Ulasan)