I have a MAKE TABLE query that updates the information
from one database to another.  Now I would like to have
this table updated automatically.  I have linked the 2
tables together, but I want the copy to be read only.  

I have two tables, one is a list of Water users for a
city with their street address,city, state, zip and the
other table is a list of multiple addresses for the Water
user if he owns additional property.  I am trying to list

Guys,
How do I set a table with multiple primary keys?

I'm running into an unusual problem in A2K2 while creating
a table on a SQL Server 2K. When I attempt to open the
table in design mode, I get an information box that tells
me "The setting for the DecimalPlaces property must be

Is there a method to reset the autonumber back to zero in the tables that contain the autonumber field.I have populated the tables with entries to test it out and now i would like to reset the autonumber.Is this possible?
Thanks for the support!

Are there any tools available to help export access 2000
mdb table schemas?

I can capture the user that is logged into my database.  I would like to take that information and update the table with this person.  I have already figured out how to get the current date/time.  Now I just need to know how to get the person in there.  Why do I want to do this?  ...

I'm making a sort of Customer and Orders database in MS
Access 2003.  My problem is that I wish to update the
table "tblTransaction" based on changes made in the
table "tblOrderDetails". There is no direct relationship

I'm looking for a way to know if a table is used in queries, forms, reports and macros
I'm using Access 2000
I've got more than 500 tables and more than 700 forms... very long job to check them one by one
I've got to do some cleaning and i don't know the application very well yet.

   I have an Access Database with two tables. In Table 1 I have Company
Name and Vendor number and other information.  In Table 2 I have a Company
Name using a Lookup in a drop down box, and that works.  But what I want is
when a user selects the Company name in Table Two I want ...

Folks, I have two databases that contain tables linked to
a common third database. When bossman tries to open them
from home, one opens after about 3 minutes. The other
times out and a window pops up saying "Program Not

Each of my two tables has the same data except the last
five fields which are different.  I'm simply trying to
combine the tables for a Report by joining the two tables
in a Query.

Does anyone know why the SQL view may not be available to
use  for a table of form? I have read that you can get the
SQL view by clicking on the view button drop down list, but
it isn't there for some reason. The only view options

How can i get the results of each timecard entry to only appear in the employee table under the employee number which is unique.It is a one to many(one employee to many timecards) but i just want the entrys to be under the one time entry of the employee number not for each ...

I need to track the number of hours a student accumulates
while taking various courses.  These hours will then need
to be added, by query, to produce a total number of hours.
My problem is that I can't use a number field because then