Other than longer fields and multi lines; what is the difference between
memo fields and text fields?
For example; Does a string of thirty characters in a memo field take up less
space than the same characters in a text field defined as eighty characters?

Does anyone have a template database for stock control that can be modified I work for a charity that can't afford to buy one

I would like to change a key value, SoftwareID, from AutoNumber  ("0037") to
Text ("WIN2KFULL"), but Access 2002 won't let me. It says a relationship
exists between my Software table and a related (CD) table. That was true,
but I broke the relationship and restarted the program. ...

I need some information about snowflake and star database design schemas.
Any help will be appreciated.
Emre Bakan.

A particular Access behaviour was brought to my attention: when you enter data in a numeric field and you go from one record to the next, always entering data in the same field, Access will fill the series 1,2 with 3,4,.. or 2,4 with 6 and so on.
example
FIeld1  Field2(numeric)
ABC  ...

I'm having a problem with storing word files in a table. I
have a field called "CV" with the data type "OLE object".
It works when I try to store .bmp files there, but when I
try with a word file, the following error message appears:

How do I get a row number from a query result? Or short of
that, is it possible to insert a column which will just
count the number of rows that have already been. (i.e.
inserting a column called "row_number")

I am using Jet CREATE TABLE statement to create an Access
table. In Acccess 2002 Help I do not see option for
defining DEFAULT values for the fields.
Is it possible to define DEFAULT values for table fields

Does anyone know where to get a good template for
controlling PC equipment inventory and issues related to
that equipment such as tracking what site the equipment is
at and repairs to the equipment? Thanks in advance.

I'm converting an excel-based database into MS Access.  As part of this, I need to compute the yield to maturity (or internal rate of return) for each bond in a bonds table.  Is there any way I can use Excel's "yield" function for this or is there an add-in available for this?

I am building an application to track my B&B guest stays and purchases, etc.
I am not a very experienced DB designer although I have a lot of experience
with using Access 2000 after design.  I want to find out if my tables are
normalized.  I just read Understanding Normalization by ...

This is probably pretty easy.  I have a backend and a
front end to an Access 97 db.  I recently added a few new
fields to the tables in the backend.  I now want to add
them to my form but, when I try, the fields I have added

For a given project (tblProjects: KF = Text 5), we have
several estimates (tblEstimates), numbered sequentially by
the user.
Originally, I designed tblEstimates with a compound key,

I am trying to generate a number for my HelpDesk table based on the current date. I would like the numbers to look like this: 0116040001 and then increment by one so not to have any duplicates. Then on the next day the ticket number will be that days date, 0117040001 or where the ...

I've a database set up to record refinery equipment for
risk based inspection.  I've reached the limit, it seems,
of 255 fields.  Thankfully, that's going to have to be
enough, but I need to change a number field (well, there's