I have added a new field to my SQL table.  I need to update the Access
database to reflect this change.  When I use Tool/Database utilities/ Linked
table manager. notheing happens.
I've done this thousands of time and never had this problem.  Any suggestions?

I have a database in Access 2003.
I have two linked tables - one with basic information on people, one with
information on a particular event.  They are linked by ID number - the main
data ID number is auto.

Can anyone give me some insight as to how to rectify this problem?
I am trying to sync and it continuously gives me this error.
PLEASE HELP!
Thanks,

I have a question about relationships. I'm not so good at designing
databases, just trying to get better.
This is the situation:
I have several objects: Mail, Depot and Action.

I'm really new to access and don't know anything about it. I have looked on
the Microsoft website and found templates for a membership database for
Access 2000. Unfortunately I am using Access 2003. Are there any free
templates out there? Am thinking editing an existing one is ...

I've executed this query via ADODB:
CREATE TABLE Trevors (trevor_name VARCHAR(15) NOT NULL UNIQUE, trevor_type
VARCHAR(5) NOT NULL, CHECK (trevor_type IN ('Mail', 'Depot')), UNIQUE
(trevor_type, trevor_name));

Is it possible to import a database done in Access to Appleworks?  And can I
import from Excel to Appleworks

Help! Can someone tell me how to prevent users from exiting the main
switchboard. Someone is changing my queries/forms. I need to be able to edit
queries/forms. I thought I went to a workshop and someone told me there was a
way of doing this. THANKS!!!!!

I am not sure if this is right group for this. I'm sorry if not. Here
is my situation:
I have aa date field that I put whatever date in (date doesn't matter)
I have 25 fields that I put a number in (1-100). I have another field

I understand that the primary key of a joining table in a many to many
relationship is the unique combination of the two foreign keys of the
tables being joined.  I also understand that this good because it
prevents duplicate entries in the joining table, but what if

How can I ascertain whom, on a network, is accessing the Access database?
On one form, I have a text box which displays who printed the form using
"=fOSUserName()", so I am wondering if I can use a similar expression in a
form or report to show me who is accessing the database ...

I have created a Database in Access 2003 in which I have created a report
that i would like to have automatically emailed - using an email address
field. Does anyone know if this is possible.

This might seem like a stupid question, but I thought it might affect the
performance of the database.
Im designing my tables at the moment for a stock control system.
Will the db perform quicker if I have fewer tables, but with more data in.

Is there a max to how many relationships you can have. I have quite a few. I
connect the two fields and set up my relationship. When close the database
and reopen to the relationship window, the relationship is gone!!!! So I
connect the 2 fields and create the relationship again, ...

I am trying to create a database where absences will be tracked.  I am
unsure about how I should design this system...
Can someone give me an example to start off with?
Thanks a lot for your help.