IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 1 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

New Also note:
While they haven't actually changed the file format of Access database files and 2003 ostensibly reads 2k MDBs with no conversion needed, they have, apparently, instituted some major changes in how VB code is compiled. This is why my procedure bumped up above the [edit] 64k limit: [link|http://support.microsoft.com/default.aspx?scid=kb;en-us;129897|see here:]

The maximum size of the internal code for an individual procedure in Visual Basic version 3.0 is 64K bytes. Microsoft Visual Basic version 4.0 for Windows uses Microsoft Visual Basic for Applications, which generates more generic internal code than does Microsoft Visual Basic version 3.0. This generic code allows for compatibility with a wider range of processors. This makes the internal code larger, so it can cause very large procedures to exceed the 64K limit and fail to compile.

What other processors they may be referring to, I have no idea. But whatever this "generic internal code" does, it can contaminate things. I changed a couple of things in a 2k form using 2003 and it became unuseable (within 2k) due to various errors. Thus, if anyone out there is going to migrate from 2k to 2003, get the KY ready and start limbering up.
Expand Edited by acagle Feb. 12, 2004, 03:39:11 PM EST
New Who will ever need more than 640K? Er, I mean 64K...

"...and pronounce all four E's in the word 'shit'"
     Passing Null values. - (acagle) - (5)
         Variant - (JayMehaffey) - (4)
             Re: Variant - (acagle) - (3)
                 Access is notorious for that - (JayMehaffey) - (2)
                     Also note: - (acagle) - (1)
                         Who will ever need more than 640K? Er, I mean 64K... -NT - (Arkadiy)

Hail Eris.
55 ms