How much code can be put into an Access 2003 database

  • Thread starter Thread starter Wim
  • Start date Start date
W

Wim

Are there any limits to the amount of VBA code that can be put into an Access
2003 database?
 
Thank you, Chris, for those numbers. They are very reassuring!
And, yes, I will stay well below the limits - I have already experienced
that Access can get out of control long before the limits are reached (in my
case it happened because I had too many fields in a table - but nowhere near
the official limit of 255).
Thanks.
 
That sounds scary.
If you can reach the limit with 16 text fields (16 X 250 = 4000), doesn't
this mean you might as well reach the limit with just 1 memo field
(supposedly up to 65 000 or so characters) ?????

Chris O'C via AccessMonster.com said:
You ran into another limit. Each data page in Jet 4.0 is 4 KB, so no record
can exceed the space left over in that data page after subtracting the space
necessary for the page definition and row definitions. You can hit the 4 KB
limitation with as few as 16 max length (255) text fields.

Chris
Microsoft MVP

Thank you, Chris, for those numbers. They are very reassuring!
And, yes, I will stay well below the limits - I have already experienced
that Access can get out of control long before the limits are reached (in my
case it happened because I had too many fields in a table - but nowhere near
the official limit of 255).
Thanks.
The limits are:
Click to expand...
[quoted text clipped - 13 lines]
Are there any limits to the amount of VBA code that can be put into an Access
2003 database?
Click to expand...
Click to expand...
Click to expand...
 
OK, that's clear.
I have one table with 24 memo fields in it. That should in principle be
possible?
 
The 24 fields contain quite different information. I don't care much where
the information is saved, but I need 24 different controls on a form to guide
the user in his/her answer. Is there another way to solve this, except for
creating 24 different fields, one for each control?
 
Chris, I am not sure if I understood you.
24 different tables with one memo field each (+ a primary key)?
You suggest I use unbound text boxes. What code would I need to have the
content of these unbound text boxes transferred to the table(s)? Can you give
an example?
Forgive my ignorance!
 
Hi Chris,

Hope you haven't forgotten about the code you would post (for the
alternative method)...
 
Back
Top