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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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?
|
#3
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 10:54 AM |