I have a database which function changed from a weekly report to a daily report and I wanted to change the table name.  Is there a way to automatically update all queries, forms and reports that would would be impacted by this name change?

I have an Access 2000 database. I created a picture field
(OLE) in one table. I then inserted 8 picture objects into
8 separate records. All of the picture files (.jpg) were
about 30KB. However these 8 pictures caused my back end

Not sure which group to place this question in.
Excuse my Duh...
I have a table whish has 2 text fields. I want to combine these
fields to make a unique ID field. Could someone explain please how I would

I want to create a project which I can keep track with my
Employees from the beginning(apply the job) until he/she
quit the job.
Could anybody please tell me how can I design my database

Has anyone heard of a problem with Access that would cause
other programs to CRASH?  We have been using a 8MB MDE (21
MB MDB) Access 2000 program with a few dozen users in it
at any given time.  It uses alot of VBA mostly with

Take a table comprising of Gender and Title. How do I set up the table such that Title is a combo field that offers options based on the value of Gender. For example, if Gender is Male, the Title Combo should offer Mr, Sir and if Gender is Female, Title should offer Ms, Mrs etc

I have a table with a field hours type is numeric and the
format I have changed from general to fixed to standard
with the results being the same. if I enter 2.34 it
returns 2 if I enter 2.67 I get 3 the only way I found to

I need some help with something that would enable a user
to do a Digital Signature on a record
Cane someone help
Frank

What is the difference in linking a table with VBA and
linking a table with File|Get External Data|Link Tables?
I want to place forms, queries etc on a few local machines
and have the data on a network drive.  I have seen code

Access 2003
I have a sign - in and sign - out database for laptop
equipment that is shared among several users.  
I have a field called "CheckedInBy" that only exist in

Is there a way to password protect a check box ?  The box
would not let you check it until the password has been
entered.  also is there a way to hide data after it has
been entered?

I wan't to copy or link a cel's text into an XL spred
sheet but access doesn't copy what I am looking at. It
seems to be copying the list index of the combo box row I
used to select the records data and not the actual text

i keep getting "You or another user may have unexpectedly
quit microsoft access while a microsoft access database
was open. Do you  want microsoft access to repair the
database?"

Please help,
I have a look up table with 20 values. I want to allow
users to open the table to add new records but not be able
to edit the first 20 that are already in the table. They

We have discovered that we are unable to cut and paste
tables between different databases in Access 2002. When
selecting "cut" then opening the other database and
selecting "paste", the paste option is greyed out and th