I gang

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.

Færdigheder: Microsoft Access, XML

Se mere: 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

Om arbejdsgiveren:
( 4 bedømmelser ) Weesp, Netherlands

Projekt-ID: #4062212

Tildelt til:

Krusche

As discussed.

€30 EUR in 7 dage
(7 bedømmelser)
4.9

7 freelancers are bidding on average €116 for this job

finecodervw

Please check PMB for more detaiils. Thanks

€250 EUR in 10 dage
(51 bedømmelser)
5.4
expertcoder1vw

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 Mere

€45 EUR in 3 dage
(10 bedømmelser)
4.3
NourElDeen

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

€50 EUR in 3 dage
(18 bedømmelser)
4.1
hemsingh1

Hi, understood the requirement ready to start. Thanks.

€50 EUR in 5 dage
(0 bedømmelser)
0.0
vasudev430

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

€200 EUR in 5 dage
(0 bedømmelser)
0.0
prashants106

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

€30 EUR in 5 dage
(0 bedømmelser)
0.0
ZhiZhang

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 Mere

€200 EUR in 5 dage
(0 bedømmelser)
0.0