Property Value is too large

[SueAccess]

I guess I have too many columns in my database and I'm getting the error message "Property value is too large" when trying to open the database table. When I was using Access 2000, I was still able to open the database but using Access 2003, the database will not open. Is there a way around this so I can open the table to fix it?

 

[RuralGuy]

Are you holding down the <SHIFT> key when you open the MDB?

 

[SueAccess]

Are you holding down the <SHIFT> key when you open the MDB?

No...should I?

 

[SueAccess]

No...should I?

I tried holding down the shift key when opening up the mdb file but it still doesn't let me open the table.

 

[RuralGuy]

Try creating a fresh db and importing everything into the new db and see if you still have the same problem.

 

[SueAccess]

Try creating a fresh db and importing everything into the new db and see if you still have the same problem.

How can I do this if I can't open the table to see what fields are in it? Is there an easy way to create a fresh db? There are a lot of fields in this table.

 

[SueAccess]

Oh wait. I think you're saying to create a new DB and not a new table?

 

[RuralGuy]

That's correct, a new Database. Maybe import just the problem table 1st and work with it.

 

[SueAccess]

How do I create a fresh DB?

 

[SueAccess]

That's correct, a new Database. Maybe import just the problem table 1st and work with it.

Even when I import the problem table into a new DB I still can't open it. I even tried importing the definitions only without the data but it doesn't open. There are too many fields in the table and Access 2000 still allowed me to open the table but Access 2003 is not letting me.

 

[RuralGuy]

Can you make adjustments to the table in ac2000? Just how many fields do you have in this table? The max is 255 in acXP and I believe ac2003 is the same.

 

[SueAccess]

Can you make adjustments to the table in ac2000? Just how many fields do you have in this table? The max is 255 in acXP and I believe ac2003 is the same.

I don't have access2000 on the computer I'm at at the moment. There are a ton of fields.

 

[RuralGuy]

I'm out of ideas on this one. Having a "ton" of fields in a record usually means someone committed "spreadsheet" on the table. That means the db is a long way from normalized and will give you grief time and again until corrected. After you back up your db then maybe some of Allen Browne's suggestions will help, but I don't think so.

 

[SueAccess]

I'm out of ideas on this one. Having a "ton" of fields in a record usually means someone committed "spreadsheet" on the table. That means the db is a long way from normalized and will give you grief time and again until corrected. After you back up your db then maybe some of Allen Browne's suggestions will help, but I don't think so.

I agree...I need to normalize the table but if I can't open it how am I going to do this?

Thanks a lot for your help anyway.

 

[RuralGuy]

As you mentioned earlier, ac2000 may be your only option at this point. Sorry Sue.