I'm trying to find out how I can do the following????
I have a product table that references a lookup to get the
ProductParentID,but then I want the database to recognise
this and then in the next field ProductChildID which is a

Is there a way of linking a table relatively?  I want to distribute a FE/BE
DB, but I don't know exactly where the folder is going to be put.  What I
want to do is link the tables in such a way that I can use
CurrentProject.Path & "\Data\BackEnd.mdb" and then the table name so that

Brief background: I have a very large 3rd party dbms
(30+Gb) from which I need to extract selected data using
an odbc link. Among that data is a table which stores
customer contact phone numbers stored as rows. In this way

I played around with the Table Analyzer Wizard. Is there a way to not use the wizard to split the database? I would like to have a few different tables.
Employees (EmployeeNumber, FirstName, LastName, Address, City, State, ZipCode, CellNumber, HomeNumber, BirthDate, HireDate, ...

I posted earlier on a query that was doubling up the values and it was suggested that the query was somehow linked.
So I'm going back to basics and trying to really understand this relationship:
I have a table of transcations.....freight invoices
main fields are:

i am using asp and an access database and here's what i'm TRYING to do
i have 3 fields in the table (hrs_taken), (date), and (hrs_needed).
i also have an update form which updates hrs_taken and date, well anyway i want the value entered in the form that updates hrs_taken
to add to ...

I have created a table with a field called "Time". The Format is Medium Time with an Input Mask of 09:00\ >LL;0;_
I have created the following records in the table:
8:00:00 AM
8:30:00 AM

I'm trying to design a database which includes Vendor
information, the Area a Vendor Services (list of states or
metropolitan ares w/in a state, for large states), and the
Region which each area belongs.  End users want to be able

Is it still 1Gb for the latest version of Access?

This question is about changing the indexed property of a linked tabl
field from code.  I'm using Access 2000 with SP1.
What ultimately needs to happen is the index property to change fro
"Indexed (Duplicates OK)" to "Indexed (No Duplicates)".  I also need t

I am currently in the process of trying to create an Access Database Application.  The database will be located on a local network and multiple laptops.  In thinking over the table structure I found a duplication problem that will cause issues when synchronizing.
For most of my ...

Working on a mailing list table with 10K plus records without any primary keys.  Most of the time, have to import from Excel spreadsheets more reocrds.  Is there anyway I can control duplication of same names etc. ??? Thanks

I have two tables:
Table 1
Subject, SubjCode
Maths, Ma

This may be a big question so I thank anyone in advance
for any help that they might be able to give. I have built
a database for tracking laboratory reagents. I would like
to add the ability in the database to track the locations

I would like to know if MS Access will allow you to use "Functions" like MS
Excel to calculate some of the columns in the DB by using data from some of
the other columns. For example, I would have a cost per gallon in a "Cost"
column and gallons used in the "Gallons Used" column. I ...