Property value is too large
- From: "Clint G via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx>
- Date: Fri, 12 Aug 2005 12:45:12 GMT
I'm starting a database for opacity testing. I'm supposed to add fields for
every six minutes in a day that are numbers from 0 to 100, with the date
itself as the primary key. As you can tell, as there are ten 6 minute
intervals in an hour and 24 hours, I should only have 241 fields, but when I
add fields and save it, I get "Property value is too large", and I had all
the number fields in the table set to byte, since I'm not gonna have any
numbers over 127 or 128. I tried denormalization, and split the big table
into two tables, and used a one to one relationship with the two tables, by
adding a Date field to the second table too. I then placed them together in a
query, and then used that query as a record source for the data entry form,
but I get the same day there twice when I cycle through records, I only need
it there once. Can you help me there? If not as a posting, you can send it to
my address at clint_gould@xxxxxxxxxxx if you wish. If you need me to explain
the problem further, let me know.
Clint
.
- Follow-Ups:
- Re: Property value is too large
- From: Allen Browne
- Re: Property value is too large
- Prev by Date: Re: require 10 digits
- Next by Date: Where can I find a template for creating a pictoral directory?
- Previous by thread: After installing Access 2003 on new drive, functions do not work
- Next by thread: Re: Property value is too large
- Index(es):
Relevant Pages
|
