W
Wim
Are there any limits to the amount of VBA code that can be put into an Access
2003 database?
2003 database?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
Wim
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.
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.
W
Wim
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) ?????
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.
[quoted text clipped - 13 lines]The limits are:Are there any limits to the amount of VBA code that can be put into an Access
2003 database?
W
Wim
OK, that's clear.
I have one table with 24 memo fields in it. That should in principle be
possible?
I have one table with 24 memo fields in it. That should in principle be
possible?
W
Wim
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?
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?
W
Wim
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!
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!
W
Wim
OK, that's clear. Will start experimenting with this. Thank you very much.
W
Wim
Hi Chris,
Hope you haven't forgotten about the code you would post (for the
alternative method)...
Hope you haven't forgotten about the code you would post (for the
alternative method)...
C
Chris O''C
David Fenton has instructions and sample code for unbound memo fields.
They're located near the end of his post.
http://groups.google.com/group/comp.databases.ms-access/msg/25e3524610bcbb79
Chris
Microsoft MVP
They're located near the end of his post.
http://groups.google.com/group/comp.databases.ms-access/msg/25e3524610bcbb79
Chris
Microsoft MVP
W
Wim
Thanks Chris,
Very useful information.
Very useful information.
Chris O''C said:David Fenton has instructions and sample code for unbound memo fields.
They're located near the end of his post.
http://groups.google.com/group/comp.databases.ms-access/msg/25e3524610bcbb79
Chris
Microsoft MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.