Setting for This Property is Too Long

[ninfan]

Hi, everyone. It's been a long time since I've posted but now I'm back with a question. We use a third party tool written in VB to create an Access MDB out of an Oracle DDL. It seems to work pretty smooth except for this one thing:

Several of the tables that are created give the following error when you open them: "The setting for this property is too long. You can enter up to either 255 or 2,048 characters for this property, depending on the data type."

I can't figure out what properties are in error on what fields. The tables are all empty. I have a mix of text, numeric and date/time fields.

Any thoughts? Thank you!

Troy

 

[jdegeorge]

Ninfan

255 is the character limitation on a text or memo field. Don't know what the 2,048 data type would be. In any event, open your table in DESIGN mode and verify each field's length.

In general, if you create a table with fields that have only the length required for each, your database will be smaller.

Hope this helps.

Jim

"Get it right the first time, that's the main thing..."

 

[ninfan]

Thanks, Jim. Here is the layout of a table with this error:

UID - Number - Long Integer
SERVCODE - Text - 50 length
STARTTIME - Date/Time
TIMESTAMP - Date/Time

This error is mystifying. If I create the table manually, it is fine. I wish I could figure out what property Access doesn't like.

Troy

 

[jdegeorge]

Troy

Guess the simple explanation doesn't always work!

Is there any way that you can save the data to a TXT file and import it into your manually created table?

It may be an extra step, but with code or macros it might not be that bad.

It won't answer your question, but is a suggested workaround. Just an idea...

Jim

"Get it right the first time, that's the main thing..."

 

[ninfan]

Jim, the table doesn't contain any data. I get the described error when I open the empty table. The issue has to be something with the table properties. My source DDL also includes field comments but they all seem to be complete too (i.e. not truncated).

I'm just concerned that users of these tables with property errors will be alarmed when they see the errors.

Thank you for the effort in considering my problem.

Troy

 

[ninfan]

Problem solved. I just found that the table description cannot exceed 255 characters. Right click/properties on a table to see the description. It accepts more characters than 255 but issues this error.

Interesting...

Thank you to Jim and any others who read my post.

Troy

 

[jdegeorge]

Troy:

I always look at database objects in LIST mode (the default), which doesn't show the table description. I didn't even know there was a table description property!

Good find!

Jim

"Get it right the first time, that's the main thing..."