I have a table, each record has a field where I have to include a picture
JPG of 80 KB average size.      For each picture I include, the MDB file
increases its size about 5 MB.
How can I include the pictures and be able to see and print them in the

How do I link 90 child tables to a single parent table?
Access only allows 30 indexes to one table.  We would like
to have referential integrity on all of them.
Should I create more "levels of organization"?

I am presently working on a Acess 2002 database being
designed for Windows and Office XP Professional based
computers.
I have developed an activities manager to manage tasks

Thank you for reading my message.  I have a form with
mutlipe tables connecting to it. One table is contacts and
one table is companies.  The form is able to show both
companies and contacts at the same time.  My problem is

I have a database with Tables
"Customer" & "CustomProducts".  
"CustomProducts" contains fields like:
CustomerID, ProductID, SellPrice, Active/Inactive, Active

I have a database with Tables
"Customers" & "CustomProducts".  
"Customers" contain all Customer Info, i.e. CustomerID,
CustomerName, Address, Phone, Etc.

I have a SalesOrder (SOTable) that is made up of many SaleItems (SItable).
Each SaleItem may or may not be made up of subparts (SSItable).
I have a Purchase Order (POtable) that needs to purchase the above items and
subitems.

I need to store information on Zones and Access Times in a database however I am having some problems with the design.
I have multiple employees.
Each employee can access any one of 32 Zones.
Each Zone is broken into 96 individual time slots per day giving the end user the ability ...

Using Access 2000, clicking on a hyperlink that is an
email address opens the web browser instead of Outlook.
Some email addresses open Outlook, others open the
browser in error. Does someone know why this happens and

I've created a master table with various fields.  For one
particular field, let's say Field B, I want the cell to
show different set of combo box for Field B, dependent on
what the user selects in Field A.  So for example, if user

Can you do this?  If so, how?

What is the maximum number of fields I can design into a
table??
Thanks
Jim

How can I get access to accept text of more than 255
chars?
If I enter more than 255 i can open the databse in
access, but the app I am writing cannot open it I am

A former employee created a database called Requests.mdb.
In the same folder are other databases named db1.mdb,
dvb2.mdb, all the way to db9.mdb. Basically, all of these
files are backups of the original database at certain

I have a master table called PeoplePlaces.  I have a
table called Relations which lists individuals related to
a record in PeoplePlaces.  I have 2 tables, RAffiliations
and RCampaigns that list specific information about the