By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,078 Members | 1,846 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,078 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

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


Boxcar74
P: 42
Hello
First if you have 186 fields you should rethink your table.

I would suggest trying the Analyze Table and/or Analyze Performance features in Access and see what they say.

With that said:
Access allows the maximum Number of fields in a table to be 255.
So you should be all set. But you not :-(

In my experiences Iíve found if I have a lot of data, in my case 400,000 rows if I try to change a field property I get a similar error.

When this has occurred:
1. I backup the DB!!!
2. Then I copy the table I have problems with.
3. Delete all data from the copy so you have an empty table
4. Change or add fields.
5. Then repopulate the table with my data.

I stress back up, back up, back up your data!!

Again If I were you I would spilt the table up either via the Table Analyzer or manually.

I hope this helps.

--- Boxcar
Jul 6 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Have a look at this tutorial for help in restructuring your database.

http://www.thescripts.com/forum/thread585228.html
Jul 7 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.