By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,230 Members | 2,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,230 IT Pros & Developers. It's quick & easy.

Error in adding fields to existing table

P: 17
Hello everyone,
I need to add 10 fields into an existing table which already has 186 fields. but i am not able to do so as i keep getting error message when i try to save the table.

Property value is too large. (Error 3309)

help on this says

"This error can appear if:
You have exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file.
The indexed property of a field was changed from Yes (Duplicates OK) to Yes (No Duplicates) when duplicate data is already present in the table."

can you help please ?

thanks
Jul 6 '07 #1
Share this Question
Share on Google+
2 Replies


BradHodge
Expert 100+
P: 166
Is there any reason that you can't split the table and then just access the new tables via a query that joins them?
Jul 6 '07 #2

NeoPa
Expert Mod 15k+
P: 31,560
Last edited by cyclops : Yesterday at 09:24 AM. Reason: sorry for posting it here... can this post be deleted?
Assuming you've already reposted in the correct forum, I'll lock this thread. If this is not right then simply PM me (or report the post) to get me to unlock it again.
Jul 7 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.