I want to design a database for a business that
manufactures UPVC windows and doors. My initial problem
is that each product (especially the windows)can be made
in various set sizes with set prices dependent on height

I am developing a table now. Whenever I saved my table, it shows "Property
value is too large" and I could not save it. I checked all my field and did
not find anything wrong. Any idea on this?
Thanks in advance!

I was wondering if you could help, this is for my A-Level
in ICT.
I have to create a database in which students details,
and course grades are stored. The database is required to

Hi Eric,
Mant thanks for that tip.  However I have more than one
word in the field ie An address field could have
something like New Gate Street in which case I need to

Folks,
I have inherited an Access 2000 database that contains about 50
records. The database is not normalized, but I'd like to make it so
without having to reenter the existing data.

I have to design a database which will have 2 Tables
Table1 and Table2. When data in Table1 Changes i can
generate a number thru query1/Expr1(based on data of
Table1) and every time this happens i want to change

Access 2000 will allow me to insert a blank into a field with the
Allow zero length property set to no.  Here is what I did.
Created a table in access with SQL. CREATE TABLE TestTable (String1
char(4),String2 char(3),String3 char(40),String4 char(13))

I would like to be able to enter a zip code into my form
and have the city and state automatically fill in from a
table. Where can you go to import zip code data?
Dave

where can i download a copy of the village , spiderman2 , or catwoman that
actually work?

      This is a continuation of an earlier thread about
Parsing strings from one field into many. I making a
database,that contains five fields of overlap and to make
the data entry easier I am trying to automate some of it.

I was under the impression that a field should always be formatted as text
if the contents were not going to be used in calculations, so I formatted
fields such as Social Security numbers and employee numbers as text.  But I
notice many examples in the NGs using numbers for this ...

I have a product table  where each prod can have from 1 to 10 suppliers
What is the correct way to build those tables?
tblProd           tblLink        tblSup
1, prod1        1,A                A,Sup1

I need to set the Allow Zero Length property of a column to true
programmatically.
Is there a way to use an ALTER TABLE query to modify an existing column's
Allow Zero Length Property?

We are having a problem with an access 2002 web page. we
used the pivot table options on the web page to give sort
options on pull downs. Users on os XP and office 2002 can
use these pull downs to select the item to sort on. Users

I had a field in one record that suddenly changed into
boxes and characters indicitive of encryption.  Now when I
change the field it immediately crashes the database.  
Entire record is connected to several other related