A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Error message -- "property value is too large"



 
 
Thread Tools Display Modes
  #1  
Old July 23rd, 2004, 03:38 PM
lizbgreen
external usenet poster
 
Posts: n/a
Default Error message -- "property value is too large"

I'm putting a survey into Access and after my last round of updates to a table, when I try to save it I get an error message saying "property value is too large". Does anyone know what this means, or how to get rid of it?
  #2  
Old July 25th, 2004, 07:02 PM
Eric Butts [MSFT]
external usenet poster
 
Posts: n/a
Default Error message -- "property value is too large"

Hi,

Sounds as if you are running into the issue noted in the following:

ACC2000: Error Saving Table Error Message After Design Change (323657)
http://support.microsoft.com/default...B;EN-US;323657


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Error message -- "property value is too large"
| thread-index: AcRwwqhVwWCSnG91SJ6rnwft9vv+DA==
| X-WBNR-Posting-Host: 198.182.163.102
| From: =?Utf-8?B?bGl6YmdyZWVu?=
| Subject: Error message -- "property value is too large"
| Date: Fri, 23 Jul 2004 07:38:02 -0700
| Lines: 1
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.157
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:82107
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| I'm putting a survey into Access and after my last round of updates to a
table, when I try to save it I get an error message saying "property value
is too large". Does anyone know what this means, or how to get rid of it?
|

  #3  
Old July 30th, 2004, 06:29 PM
tiz
external usenet poster
 
Posts: n/a
Default Error message -- "property value is too large"

Eric:
I was assigned to create a db in access for different customers. We are to collect info from them for three consecutive months. At first, I decided that it would be easier if I had a table for each month just to keep things simple when trying to create a query based on this three months. I also have an additional table with the customer’s info and one field in this table is called Business Days. The primary key of the customer’s info table is called Customer’s Code, this is a value that I assign manually. When trying to create a query based on these four tables, I encountered a small problem when trying to divide by Business Days. To this, somebody pointed out that even though each Customer’s Code had only one specified number for Business Days, access didn’t quite understand this. He solved my problem by putting a “MAX” in front of Business Days.

The next problem was encountered when trying to create a form out of the four tables and the query. I wanted to do this because the people that will be using the database will like to see all of this information at once. They actually have their info in Excel, but they are entering so much data in that they are worried that it will get corrupted, and decided that it was better to have the info in access. I tried to use the wizard at first, but a message shows up and it is practically letting me know that I cannot create a form based on those four tables and that query because the query is based on those tables. Don’t quite understand the reason for this.

So then, I decided to have just two tables, one for the customer’s info and one for the three months. That is when the “property value message” started showing up. I read the advice you age this other girl and it really helped me, so that is why I’m writing you. The new table I was trying to create was going to have 196 fields with extra large names, but after the problem I encountered, and after reading the info in your link, I decided to follow resolution method # 2. Therefore, at this point I’m back to my four tables. So now my problem is basically the form I have to create. I’m starting to wonder if it would be better to keep this info in excel basically because of presentation issues. Or would it be better to have a combination of both? At this point, I believe that they would prefer everything in access. So if you have access suggestions before offering a combination of both, it would be awesome. I also believe that it is important to know that I’m not an access master.

Thanks very much for your time and sorry for such a long reply.

B

"Eric Butts [MSFT]" wrote:

Hi,

Sounds as if you are running into the issue noted in the following:

ACC2000: Error Saving Table Error Message After Design Change (323657)
http://support.microsoft.com/default...B;EN-US;323657


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Error message -- "property value is too large"
| thread-index: AcRwwqhVwWCSnG91SJ6rnwft9vv+DA==
| X-WBNR-Posting-Host: 198.182.163.102
| From: =?Utf-8?B?bGl6YmdyZWVu?=
| Subject: Error message -- "property value is too large"
| Date: Fri, 23 Jul 2004 07:38:02 -0700
| Lines: 1
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.157
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:82107
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| I'm putting a survey into Access and after my last round of updates to a
table, when I try to save it I get an error message saying "property value
is too large". Does anyone know what this means, or how to get rid of it?
|


  #4  
Old August 1st, 2004, 08:34 PM
Eric Butts [MSFT]
external usenet poster
 
Posts: n/a
Default Error message -- "property value is too large"

Wow... that's a lot of information!!

I'll try my best to give you the best advice.

"...We are to collect info from them for three consecutive months. At
first, I decided that it would be easier if I had a table for each month
just to keep things simple when trying to create a query based on this
three months..."

- Normalize your data by creating ONE table that has a field for the month,
example

RecordID TransAmt CustomerID fldMONTH

This way you can create your query displaying your data for the particular
months of interest.

I hope this helps.

Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights





--------------------
| Thread-Topic: Error message -- "property value is too large"
| thread-index: AcR2WrRGoSsd3LDORJq2bqYhN/viyg==
| X-WBNR-Posting-Host: 168.215.135.201
| From: =?Utf-8?B?dGl6?=
| References:

| Subject: Error message -- "property value is too large"
| Date: Fri, 30 Jul 2004 10:29:01 -0700
| Lines: 72
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:82192
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Eric:
| I was assigned to create a db in access for different customers. We are
to collect info from them for three consecutive months. At first, I decided
that it would be easier if I had a table for each month just to keep things
simple when trying to create a query based on this three months. I also
have an additional table with the customer’s info and one field in this
table is called Business Days. The primary key of the customer’s info
table is called Customer’s Code, this is a value that I assign manually.
When trying to create a query based on these four tables, I encountered a
small problem when trying to divide by Business Days. To this, somebody
pointed out that even though each Customer’s Code had only one specified
number for Business Days, access didn’t quite understand this. He solved
my problem by putting a “MAX” in front of Business Days.
|
| The next problem was encountered when trying to create a form out of the
four tables and the query. I wanted to do this because the people that will
be using the database will like to see all of this information at once.
They actually have their info in Excel, but they are entering so much data
in that they are worried that it will get corrupted, and decided that it
was better to have the info in access. I tried to use the wizard at first,
but a message shows up and it is practically letting me know that I cannot
create a form based on those four tables and that query because the query
is based on those tables. Don’t quite understand the reason for this.
|
| So then, I decided to have just two tables, one for the customer’s info
and one for the three months. That is when the “property value message”
started showing up. I read the advice you age this other girl and it really
helped me, so that is why I’m writing you. The new table I was trying to
create was going to have 196 fields with extra large names, but after the
problem I encountered, and after reading the info in your link, I decided
to follow resolution method # 2. Therefore, at this point I’m back to my
four tables. So now my problem is basically the form I have to create.
I’m starting to wonder if it would be better to keep this info in excel
basically because of presentation issues. Or would it be better to have a
combination of both? At this point, I believe that they would prefer
everything in access. So if you have access suggestions before offering a
combination of both, it would be awesome. I also believe that it is
important to know that I’m not an access master.
|
| Thanks very much for your time and sorry for such a long reply.
|
| B
|
| "Eric Butts [MSFT]" wrote:
|
| Hi,
|
| Sounds as if you are running into the issue noted in the following:
|
| ACC2000: Error Saving Table Error Message After Design Change (323657)
|
http://support.microsoft.com/default...B;EN-US;323657
|
|
| I hope this helps! If you have additional questions on this topic,
please
| respond back to this posting.
|
|
| Regards,
|
| Eric Butts
| Microsoft Access Support
|
| "Microsoft Security Announcement: Have you installed the patch for
| Microsoft Security Bulletin MS03-026? If not Microsoft strongly
advises
| you to review the information at the following link regarding Microsoft
| Security Bulletin MS03-026
| http://www.microsoft.com/security/security_bulletins/ms03-026.asp
and/or
| to visit Windows Update at http://windowsupdate.microsoft.com/ to
install
| the patch. Running the SCAN program from the Windows Update site will
help
| to insure you are current with all security patches, not just MS03-026."
|
| This posting is provided "AS IS" with no warranties, and confers no
rights
|
|
| --------------------
| | Thread-Topic: Error message -- "property value is too large"
| | thread-index: AcRwwqhVwWCSnG91SJ6rnwft9vv+DA==
| | X-WBNR-Posting-Host: 198.182.163.102
| | From: =?Utf-8?B?bGl6YmdyZWVu?=
| | Subject: Error message -- "property value is too large"
| | Date: Fri, 23 Jul 2004 07:38:02 -0700
| | Lines: 1
| | Message-ID:
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | Newsgroups: microsoft.public.access.tablesdbdesign
| | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.157
| | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| | Xref: cpmsftngxa06.phx.gbl
microsoft.public.access.tablesdbdesign:82107
| | X-Tomcat-NG: microsoft.public.access.tablesdbdesign
| |
| | I'm putting a survey into Access and after my last round of updates
to a
| table, when I try to save it I get an error message saying "property
value
| is too large". Does anyone know what this means, or how to get rid of
it?
| |
|
|
|

  #5  
Old August 2nd, 2004, 02:21 PM
tiz
external usenet poster
 
Posts: n/a
Default Error message -- "property value is too large"

Eric:
I don't know if you read all of my long and boring e-mail, so I guess I'll try to write a really short one. I tried joining the three tables (one for each month) into one. The problem is that I was going to have 196 fields in total and that is when "property value is too large" started showing up. Therefore I decided that it waws better to have them separately. That was an advice in the link that you offered before. My problem now is that when I'm trying to create a form based on those tables and the query that I did (which is based on those tables), it is not letting me. It is saying something that since the query is based on the tables I can't do that? Any suggestions, as I need to display all of this data at once?

Thanks again,
B

"Eric Butts [MSFT]" wrote:

Wow... that's a lot of information!!

I'll try my best to give you the best advice.

"...We are to collect info from them for three consecutive months. At
first, I decided that it would be easier if I had a table for each month
just to keep things simple when trying to create a query based on this
three months..."

- Normalize your data by creating ONE table that has a field for the month,
example

RecordID TransAmt CustomerID fldMONTH

This way you can create your query displaying your data for the particular
months of interest.

I hope this helps.

Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights





--------------------
| Thread-Topic: Error message -- "property value is too large"
| thread-index: AcR2WrRGoSsd3LDORJq2bqYhN/viyg==
| X-WBNR-Posting-Host: 168.215.135.201
| From: =?Utf-8?B?dGl6?=
| References:

| Subject: Error message -- "property value is too large"
| Date: Fri, 30 Jul 2004 10:29:01 -0700
| Lines: 72
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:82192
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Eric:
| I was assigned to create a db in access for different customers. We are
to collect info from them for three consecutive months. At first, I decided
that it would be easier if I had a table for each month just to keep things
simple when trying to create a query based on this three months. I also
have an additional table with the customer’s info and one field in this
table is called Business Days. The primary key of the customer’s info
table is called Customer’s Code, this is a value that I assign manually.
When trying to create a query based on these four tables, I encountered a
small problem when trying to divide by Business Days. To this, somebody
pointed out that even though each Customer’s Code had only one specified
number for Business Days, access didn’t quite understand this. He solved
my problem by putting a “MAX” in front of Business Days.
|
| The next problem was encountered when trying to create a form out of the
four tables and the query. I wanted to do this because the people that will
be using the database will like to see all of this information at once.
They actually have their info in Excel, but they are entering so much data
in that they are worried that it will get corrupted, and decided that it
was better to have the info in access. I tried to use the wizard at first,
but a message shows up and it is practically letting me know that I cannot
create a form based on those four tables and that query because the query
is based on those tables. Don’t quite understand the reason for this.
|
| So then, I decided to have just two tables, one for the customer’s info
and one for the three months. That is when the “property value message”
started showing up. I read the advice you age this other girl and it really
helped me, so that is why I’m writing you. The new table I was trying to
create was going to have 196 fields with extra large names, but after the
problem I encountered, and after reading the info in your link, I decided
to follow resolution method # 2. Therefore, at this point I’m back to my
four tables. So now my problem is basically the form I have to create.
I’m starting to wonder if it would be better to keep this info in excel
basically because of presentation issues. Or would it be better to have a
combination of both? At this point, I believe that they would prefer
everything in access. So if you have access suggestions before offering a
combination of both, it would be awesome. I also believe that it is
important to know that I’m not an access master.
|
| Thanks very much for your time and sorry for such a long reply.
|
| B
|
| "Eric Butts [MSFT]" wrote:
|
| Hi,
|
| Sounds as if you are running into the issue noted in the following:
|
| ACC2000: Error Saving Table Error Message After Design Change (323657)
|
http://support.microsoft.com/default...B;EN-US;323657
|
|
| I hope this helps! If you have additional questions on this topic,
please
| respond back to this posting.
|
|
| Regards,
|
| Eric Butts
| Microsoft Access Support
|
| "Microsoft Security Announcement: Have you installed the patch for
| Microsoft Security Bulletin MS03-026? If not Microsoft strongly
advises
| you to review the information at the following link regarding Microsoft
| Security Bulletin MS03-026
| http://www.microsoft.com/security/security_bulletins/ms03-026.asp
and/or
| to visit Windows Update at http://windowsupdate.microsoft.com/ to
install
| the patch. Running the SCAN program from the Windows Update site will
help
| to insure you are current with all security patches, not just MS03-026."
|
| This posting is provided "AS IS" with no warranties, and confers no
rights
|
|
| --------------------
| | Thread-Topic: Error message -- "property value is too large"
| | thread-index: AcRwwqhVwWCSnG91SJ6rnwft9vv+DA==
| | X-WBNR-Posting-Host: 198.182.163.102
| | From: =?Utf-8?B?bGl6YmdyZWVu?=
| | Subject: Error message -- "property value is too large"
| | Date: Fri, 23 Jul 2004 07:38:02 -0700
| | Lines: 1
| | Message-ID:
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | Newsgroups: microsoft.public.access.tablesdbdesign
| | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.157
| | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| | Xref: cpmsftngxa06.phx.gbl
microsoft.public.access.tablesdbdesign:82107
| | X-Tomcat-NG: microsoft.public.access.tablesdbdesign
| |
| | I'm putting a survey into Access and after my last round of updates
to a
| table, when I try to save it I get an error message saying "property
value
| is too large". Does anyone know what this means, or how to get rid of
it?
| |
|
|
|


  #6  
Old August 2nd, 2004, 02:31 PM
tiz
external usenet poster
 
Posts: n/a
Default Error message -- "property value is too large"

Eric:
I don't know if you read all of my long and boring e-mail before, so I'll try to keep it short this time. I already tried to put the three tables that I had (each one for each month) together. The problem is that I was going to end up with 196 fields, which was never possible because the error "property value is too large" started showing up. I read in a link that you posted that I would be better off having separate tables with a one-to-one relationship. Following that advice, I created a query based on these tables. My problem now is that I'm trying to create a form based on these tables and this query but a message comes up saying that I will not be able to do so because the query is based on those tables. I need to be able to display all of this info at once. A report is not good enough because the users need to be able to modify the tables within the form. Any suggestions?

Thanks again,
B

"Eric Butts [MSFT]" wrote:

Wow... that's a lot of information!!

I'll try my best to give you the best advice.

"...We are to collect info from them for three consecutive months. At
first, I decided that it would be easier if I had a table for each month
just to keep things simple when trying to create a query based on this
three months..."

- Normalize your data by creating ONE table that has a field for the month,
example

RecordID TransAmt CustomerID fldMONTH

This way you can create your query displaying your data for the particular
months of interest.

I hope this helps.

Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights





--------------------
| Thread-Topic: Error message -- "property value is too large"
| thread-index: AcR2WrRGoSsd3LDORJq2bqYhN/viyg==
| X-WBNR-Posting-Host: 168.215.135.201
| From: =?Utf-8?B?dGl6?=
| References:

| Subject: Error message -- "property value is too large"
| Date: Fri, 30 Jul 2004 10:29:01 -0700
| Lines: 72
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:82192
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Eric:
| I was assigned to create a db in access for different customers. We are
to collect info from them for three consecutive months. At first, I decided
that it would be easier if I had a table for each month just to keep things
simple when trying to create a query based on this three months. I also
have an additional table with the customer’s info and one field in this
table is called Business Days. The primary key of the customer’s info
table is called Customer’s Code, this is a value that I assign manually.
When trying to create a query based on these four tables, I encountered a
small problem when trying to divide by Business Days. To this, somebody
pointed out that even though each Customer’s Code had only one specified
number for Business Days, access didn’t quite understand this. He solved
my problem by putting a “MAX” in front of Business Days.
|
| The next problem was encountered when trying to create a form out of the
four tables and the query. I wanted to do this because the people that will
be using the database will like to see all of this information at once.
They actually have their info in Excel, but they are entering so much data
in that they are worried that it will get corrupted, and decided that it
was better to have the info in access. I tried to use the wizard at first,
but a message shows up and it is practically letting me know that I cannot
create a form based on those four tables and that query because the query
is based on those tables. Don’t quite understand the reason for this.
|
| So then, I decided to have just two tables, one for the customer’s info
and one for the three months. That is when the “property value message”
started showing up. I read the advice you age this other girl and it really
helped me, so that is why I’m writing you. The new table I was trying to
create was going to have 196 fields with extra large names, but after the
problem I encountered, and after reading the info in your link, I decided
to follow resolution method # 2. Therefore, at this point I’m back to my
four tables. So now my problem is basically the form I have to create.
I’m starting to wonder if it would be better to keep this info in excel
basically because of presentation issues. Or would it be better to have a
combination of both? At this point, I believe that they would prefer
everything in access. So if you have access suggestions before offering a
combination of both, it would be awesome. I also believe that it is
important to know that I’m not an access master.
|
| Thanks very much for your time and sorry for such a long reply.
|
| B
|
| "Eric Butts [MSFT]" wrote:
|
| Hi,
|
| Sounds as if you are running into the issue noted in the following:
|
| ACC2000: Error Saving Table Error Message After Design Change (323657)
|
http://support.microsoft.com/default...B;EN-US;323657
|
|
| I hope this helps! If you have additional questions on this topic,
please
| respond back to this posting.
|
|
| Regards,
|
| Eric Butts
| Microsoft Access Support
|
| "Microsoft Security Announcement: Have you installed the patch for
| Microsoft Security Bulletin MS03-026? If not Microsoft strongly
advises
| you to review the information at the following link regarding Microsoft
| Security Bulletin MS03-026
| http://www.microsoft.com/security/security_bulletins/ms03-026.asp
and/or
| to visit Windows Update at http://windowsupdate.microsoft.com/ to
install
| the patch. Running the SCAN program from the Windows Update site will
help
| to insure you are current with all security patches, not just MS03-026."
|
| This posting is provided "AS IS" with no warranties, and confers no
rights
|
|
| --------------------
| | Thread-Topic: Error message -- "property value is too large"
| | thread-index: AcRwwqhVwWCSnG91SJ6rnwft9vv+DA==
| | X-WBNR-Posting-Host: 198.182.163.102
| | From: =?Utf-8?B?bGl6YmdyZWVu?=
| | Subject: Error message -- "property value is too large"
| | Date: Fri, 23 Jul 2004 07:38:02 -0700
| | Lines: 1
| | Message-ID:
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | Newsgroups: microsoft.public.access.tablesdbdesign
| | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.157
| | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| | Xref: cpmsftngxa06.phx.gbl
microsoft.public.access.tablesdbdesign:82107
| | X-Tomcat-NG: microsoft.public.access.tablesdbdesign
| |
| | I'm putting a survey into Access and after my last round of updates
to a
| table, when I try to save it I get an error message saying "property
value
| is too large". Does anyone know what this means, or how to get rid of
it?
| |
|
|
|


  #7  
Old August 3rd, 2004, 07:23 PM
Eric Butts [MSFT]
external usenet poster
 
Posts: n/a
Default Error message -- "property value is too large"

Hi,

I would revisit your database design. To have 196 fields really shows your
database application is not normalized. Give me an idea as to why you need
196 fields.

I hope is not something like:
1/1/96 1/2/96 1/3/96 1/4/96 and so on....


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Thread-Topic: Error message -- "property value is too large"
| thread-index: AcR4lPUulHNV0TDEQGOBywl0SnI7iA==
| X-WBNR-Posting-Host: 168.215.135.201
| From: =?Utf-8?B?dGl6?=
| References:



| Subject: Error message -- "property value is too large"
| Date: Mon, 2 Aug 2004 06:31:03 -0700
| Lines: 190
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:82385
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Eric:
| I don't know if you read all of my long and boring e-mail before, so I'll
try to keep it short this time. I already tried to put the three tables
that I had (each one for each month) together. The problem is that I was
going to end up with 196 fields, which was never possible because the error
"property value is too large" started showing up. I read in a link that you
posted that I would be better off having separate tables with a one-to-one
relationship. Following that advice, I created a query based on these
tables. My problem now is that I'm trying to create a form based on these
tables and this query but a message comes up saying that I will not be able
to do so because the query is based on those tables. I need to be able to
display all of this info at once. A report is not good enough because the
users need to be able to modify the tables within the form. Any suggestions?
|
| Thanks again,
| B
|
| "Eric Butts [MSFT]" wrote:
|
| Wow... that's a lot of information!!
|
| I'll try my best to give you the best advice.
|
| "...We are to collect info from them for three consecutive months. At
| first, I decided that it would be easier if I had a table for each
month
| just to keep things simple when trying to create a query based on this
| three months..."
|
| - Normalize your data by creating ONE table that has a field for the
month,
| example
|
| RecordID TransAmt CustomerID fldMONTH
|
| This way you can create your query displaying your data for the
particular
| months of interest.
|
| I hope this helps.
|
| Regards,
|
| Eric Butts
| Microsoft Access Support
|

| "Microsoft Security Announcement: Have you installed the patch for
| Microsoft Security Bulletin MS03-026? If not Microsoft strongly
advises
| you to review the information at the following link regarding Microsoft
| Security Bulletin MS03-026
| http://www.microsoft.com/security/security_bulletins/ms03-026.asp
and/or
| to visit Windows Update at http://windowsupdate.microsoft.com/ to
install
| the patch. Running the SCAN program from the Windows Update site will
help
| to insure you are current with all security patches, not just MS03-026."
|
| This posting is provided "AS IS" with no warranties, and confers no
rights
|
|
|
|
|
| --------------------
| | Thread-Topic: Error message -- "property value is too large"
| | thread-index: AcR2WrRGoSsd3LDORJq2bqYhN/viyg==
| | X-WBNR-Posting-Host: 168.215.135.201
| | From: =?Utf-8?B?dGl6?=
| | References:
|
| | Subject: Error message -- "property value is too large"
| | Date: Fri, 30 Jul 2004 10:29:01 -0700
| | Lines: 72
| | Message-ID:
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 8bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | Newsgroups: microsoft.public.access.tablesdbdesign
| | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| | Xref: cpmsftngxa10.phx.gbl
microsoft.public.access.tablesdbdesign:82192
| | X-Tomcat-NG: microsoft.public.access.tablesdbdesign
| |
| | Eric:
| | I was assigned to create a db in access for different customers. We
are
| to collect info from them for three consecutive months. At first, I
decided
| that it would be easier if I had a table for each month just to keep
things
| simple when trying to create a query based on this three months. I also
| have an additional table with the customer’s info and one field
in this
| table is called Business Days. The primary key of the customer’s
info
| table is called Customer’s Code, this is a value that I assign
manually.
| When trying to create a query based on these four tables, I encountered
a
| small problem when trying to divide by Business Days. To this, somebody
| pointed out that even though each Customer’s Code had only one
specified
| number for Business Days, access didn’t quite understand this.
He solved
| my problem by putting a “MAX” in front of Business Days.
| |
| | The next problem was encountered when trying to create a form out of
the
| four tables and the query. I wanted to do this because the people that
will
| be using the database will like to see all of this information at once.
| They actually have their info in Excel, but they are entering so much
data
| in that they are worried that it will get corrupted, and decided that
it
| was better to have the info in access. I tried to use the wizard at
first,
| but a message shows up and it is practically letting me know that I
cannot
| create a form based on those four tables and that query because the
query
| is based on those tables. Don’t quite understand the reason for
this.
| |
| | So then, I decided to have just two tables, one for the customerâ€
™s info
| and one for the three months. That is when the “property value
message”
| started showing up. I read the advice you age this other girl and it
really
| helped me, so that is why I’m writing you. The new table I was
trying to
| create was going to have 196 fields with extra large names, but after
the
| problem I encountered, and after reading the info in your link, I
decided
| to follow resolution method # 2. Therefore, at this point I’m
back to my
| four tables. So now my problem is basically the form I have to create.
| I’m starting to wonder if it would be better to keep this info
in excel
| basically because of presentation issues. Or would it be better to have
a
| combination of both? At this point, I believe that they would prefer
| everything in access. So if you have access suggestions before offering
a
| combination of both, it would be awesome. I also believe that it is
| important to know that I’m not an access master.
| |
| | Thanks very much for your time and sorry for such a long reply.
| |
| | B
| |
| | "Eric Butts [MSFT]" wrote:
| |
| | Hi,
| |
| | Sounds as if you are running into the issue noted in the following:
| |
| | ACC2000: Error Saving Table Error Message After Design Change
(323657)
| |
http://support.microsoft.com/default...B;EN-US;323657
| |
| |
| | I hope this helps! If you have additional questions on this topic,
| please
| | respond back to this posting.
| |
| |
| | Regards,
| |
| | Eric Butts
| | Microsoft Access Support
| |
| | "Microsoft Security Announcement: Have you installed the patch for
| | Microsoft Security Bulletin MS03-026? If not Microsoft strongly
| advises
| | you to review the information at the following link regarding
Microsoft
| | Security Bulletin MS03-026
| | http://www.microsoft.com/security/security_bulletins/ms03-026.asp
| and/or
| | to visit Windows Update at http://windowsupdate.microsoft.com/ to
| install
| | the patch. Running the SCAN program from the Windows Update site
will
| help
| | to insure you are current with all security patches, not just
MS03-026."
| |
| | This posting is provided "AS IS" with no warranties, and confers no
| rights
| |
| |
| | --------------------
| | | Thread-Topic: Error message -- "property value is too large"
| | | thread-index: AcRwwqhVwWCSnG91SJ6rnwft9vv+DA==
| | | X-WBNR-Posting-Host: 198.182.163.102
| | | From: =?Utf-8?B?bGl6YmdyZWVu?=

| | | Subject: Error message -- "property value is too large"
| | | Date: Fri, 23 Jul 2004 07:38:02 -0700
| | | Lines: 1
| | | Message-ID:
| | | MIME-Version: 1.0
| | | Content-Type: text/plain;
| | | charset="Utf-8"
| | | Content-Transfer-Encoding: 7bit
| | | X-Newsreader: Microsoft CDO for Windows 2000
| | | Content-Class: urn:content-classes:message
| | | Importance: normal
| | | Priority: normal
| | | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | | Newsgroups: microsoft.public.access.tablesdbdesign
| | | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.157
| | | Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| | | Xref: cpmsftngxa06.phx.gbl
| microsoft.public.access.tablesdbdesign:82107
| | | X-Tomcat-NG: microsoft.public.access.tablesdbdesign
| | |
| | | I'm putting a survey into Access and after my last round of
updates
| to a
| | table, when I try to save it I get an error message saying
"property
| value
| | is too large". Does anyone know what this means, or how to get rid
of
| it?
| | |
| |
| |
| |
|
|
|

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
scrolling programmatically? alekm New Users 1 July 6th, 2004 02:56 AM
Changing field indexed property from code Christopher Database Design 0 June 11th, 2004 03:17 PM
Formula Property - Referencing Strings Inside Formula Property Value Oak Worksheet Functions 8 February 10th, 2004 11:54 AM


All times are GMT +1. The time now is 03:52 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.