mdb and mde size and performance

[dave]

Does the
1. amount of comments in VBA
2. amount of white space in VBA
3. length of variable names

make any difference to the physical access file size or the performance of
the application

for both mdb and mde files?

Thanks

 

[John Vinson]

Does the
1. amount of comments in VBA
2. amount of white space in VBA
3. length of variable names

make any difference to the physical access file size or the performance of
the application

for both mdb and mde files?

Thanks

1) and 2) are trimmed out and do not exist in .mde files, but they
will affect the size of .mdb files. Variable names - I presume - will
affect the size in either case. I don't think there'd be much if any
effect on performance in any case.