An odd thing I’ve discovered while working With Access 2000/XP & SQL Server 2000:
The base size of the database that runs The Pencilcase is 9.8MB as created in AccessXP. However, after having scaled it up to SQL Server 2000 for a project, then scaled that DB back down to Access for another project, the new Access file is about 1.9MB. Which is a sizeable difference, seeing as it contains exactly the same difference. Further tests of upscaling & downscaling other databases through the process revealed similar results.
Does Access just store that much extra information about a file? It seems quite strange to me that it would need to. Or perhaps I’m losing information somewhere – I know when I upscale I seem to lose relationship information (although indexing seems to upscale fine). Perhaps when I downscale I lose this also. Although, it must be said, I’ve yet to notice any difference in behaviour in using Access through ODBC whether I’ve taken the time to create relationships or not. I think in Access they are perhaps a modeling tool rather than a data-integrity tool.
Anyone else able to shine any light onto this mystery?