table Design - Access error 3309 Property Value too large

[dziodj]

I am trying to duplicate an existing table design specification, building a big table (253 fields) with about 80 linked to preexisting lookup tables. After adding a certain number of these lookup specifications, the table refuses to be stored, with error 3309: Property value is to large; and further insists there is an attempt to store a value over 2K in length. Removing a few of these lookup specifications allows me to resave the table. The "Access Maximum Capacities" documents do not discuss this limitation. Do I have to break this into several smaller tables?

 

[LittleSmudge]

What do you mean by "lookup specifications" ?

You are not, I hope, creating "Lookup FIELDS" within the table are you !





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[dziodj]

Hmmmm... and, so what if I am, indeed, creating "lookup fields"???? I'm sensing from the mocking, superior tone of your response that this is a somehow broken feature, that any breathing mammal would have instinctively crawled away from. Gimme a break, I'm new to Access and don't yet know what doesn't really work... sounds like I maybe stepped directly into a smelly one, right out of the gate.

 

[RoyVidar]

Yup;-)

Here's some more "rubbing it in" The Evils of Lookup Fields in Tables - but the link also explains why ;-)

While visiting that site, which is a very good Access site, with lots of very good tips, code suggestions ... also check out the link to the 10 Commandments, which also lists/sums up what seems to be a pretty much agreed upon standard among Access developers. This will help you avoid many of the common mistakes while getting to know Access.

Also Welcome to Tek-Tips!

There are some tips for how to get the most out of the membership here faq181-2886.

Good Luck!

Roy-Vidar

 

[LittleSmudge]

dziodj I'm sorry if you took my comments as mocking or in any way superior.

I was genuinely unsure of what you meant by 'Lookup specifications'.

Having said that, the link provided by Roy clearly indicates why any 'intelligent, thinking and educated' mammal would run headlong away from these things.

They rank alongside putting space characters in object names under the heading of "Just because you CAN doesn't make it a good idea to do. - Avoid like the plague."


Finally,
Welcome to tek-tips.
This is a great board to gain ideas, help, knowledge, but don't take ANY comment on these boards too harshly.
Some of us 'old hands' occasionally forget that new guys on the block don't have years of experience or the hard skin of a tortoise !

'ope-that-'elps.


G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[dziodj]

Thank you all. No, I was not bruised; I just enjoy a bit of melodrama. Your help is appreciated; thanks again for your response.