Hi,
I have 2 computers here;
PC #1 :
Windows 2012 server 64bits, with Microsoft Office 2010 32bits.
PC #2 :
Windows 2010 64bits, with Microsoft Office 2010 32bits.
I have a Frontend 100% VBA process that I run, with a timer in milisecond. (it's a data copy from table A, B, C, D, to Table E)
All tables are in the backend.accdb database.
When I compact my backend .accdb with PC #1, the process take 77sec to complete.
When I compact my backend .accdb with PC #2, the process take 7sec to compete.
I always run the frontend process in the same folder, on PC #1
The backend database is always in the same folder, on PC #1
So, I only use another PC for compacting and it increase performance.
If I compact with PC#1, its slow, if I compact it with PC #2 then it will be fast, and if I use PC #1 again it will be slow again...
why...