Can we say MS-Access as True RDBMS?, What are the key differences between the
RDBMS (Sql-Server) and MS-Access

Is it possible to have cascading deletes set up between normal tables and a
linked table in another db?
The option isn't available in the relationship editor in the frontend where
the non-linked tables are.

Does anyone know why an Access DB grows so much and you have to run the
compact/repair tool every day to keep the file size down?
TIA,
Jarryd

Hi Folks - I'm totally confused ..... I'd like to add bound pictures to a
table. I create a field with the OLE data type. I right-click on said field,
choose Insert Object, navigate to the folder with the picture (bmp), and
make sure I check the link option. My uneducated guess is ...

I am trying to set up a housing schedule.  I would like to set up a table
with the following structure for each house.
House#1
Task        Start Date    End Date    Duration  

i am constructing a survey for my organization.  i have looked at Mr.
Hookum's AYS.dbm.  I am not sure how to apply what i am doing to that concept
he has presented.  so i am going to lay out the basic info and see if you
guys or gals can help me get a design going.  

I have created an application and split it between a front end and back end.  
However, I have discovered that the field properties of a field as shown in
the back end (looking directly at the tables)  and in my front end are not
identical.  (One shows it as a text box, the other ...

My goal is to have a recipe database in which I can enter
recipes and the ingredients they use and then filter the
recipes based on ingredients available on-hand.
I have tried to have a recipe table and then use an

I set up a combo box in my data to pull up some values from a table.  When I
type the information in the table and save it and then go to forms to see if
the values pulled up nothing shows up but the name of the company in the
combo box.  I have tried putting all of the values ...

Hitting a snag in my design and could use some help.  I tried implementing a
suggestion by another in the MS discussion groups, but my command button
still didn't work.  Here's the scenario:
I'm using a continuous form with a command button to allow the user to open

I'm using Access2003.
I've created a table that I'm adding,deleting, and modifying the contents of
the record in the table.
The table has three fields. Date(mm/dd/yy),PartNumber, and QuantityRequired

Don't know why, but all of the Relationships in my database are missing. A
review of backup files shows they were present until 4/5 and have been
missing since 4/6. Couple quick questions.
- Any ideas on how they may have been deleted?  It's a multi-user database,

Hi i am in urgent need of creating a way that a person can use a combo box on
a main form to search and automatically go to the selected information on
another form

My goal is to prompt users to enter in their Beacon (credit) score and BNI
Score and Access will query the table and generate the correct interest rate.
But I'm having trouble with the large range of numbers.   I need a column for
the Beacon score with a possibility between 800 ...

How do you add data to relational tables.  Example: The main table is
"tblCustomerProfile" and two relational tables called "tblParkways"
"tblFleetInformation"  
When I add a new customer I need to add information to the two relational