Is it possible to connect two foreign keys? if so, is this desirable? Why not?
This is a strange question for me. But Access is so limited i've run out of
options.

I need to clear about 200,000 checkmarks in my database, does anyone know how
I can do this? I have tried REPLACE with (-1 with 0) and (Yes with No) but it
does not change the Checkboxes
Thanks,

I am currently in the process of designing a database and my knowledge of
Access 2002 is not too strong. We have 26 remote sites which provide
Employment Services to the public, the database I'm wishing to create will
record all job applications. Currently we have a database for ...

Access 2003  Win 2k
I have a table that I need to add and delete records to.  However there is
an error message that tells me that the table is read only.  Also the new
record feild doesn not appear.

I have a table that has over 500 records and those records have a 'taskId'
as the primary key.  Each of the records relate to what the task is that can
be done in a project.
What I am looking to accomplish now is have a form where all 500+ tasks show

How to generate a password in all the records of the field of a table?
Example: tblStudent with the fields [LastName], [First name], [Street], etc.
Is it possible to generate it starting from the last name of the user?
Thank you in advance

I am using Office 2003.  Included is an example database named Northwind.mdb
that has an image associated with each record.  I am try to mimic that
function.
In my database I have a field of type OLE Object.  When I try to use "Insert

I have created 5 tables and each has an ID field of auto number. I have
joined the tables using ID# and when I go to show relationship the joining
lines appear.
Problem 1-I have created a form which uses the ID# from table 1 and then

In importing a dbf file into Access, I have run into the following problem.  
There is a numeric 2 digit mo field, a numeric 2 digit day field, a numeric 4
digit year field, and 4 character time field with leading 0 when necessary.  
I can build an expression that creates the Short ...

Hi, This should be simple for you guys.
We need to record credit card details including "Expiry Date" in the form of
"DD/YY".
How do we best format the field for easy entry AND validation (i.e. as a

Please an you have templates for CV's for jobs thank you
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I

I am creating a simple database to maintain survey data and calculate some
statistics. I work for myself but there might be an oppportunity to sell my
Intellectual Property which would include the database.
Can anyone point me in the direction of what this means in terms of

I have been importing .csv files into Access using a Macro which work
great.  Unfortunately, the task has become more intense.  I now hav
20-50 csv files to import the data from.  The names of the file
change over time.  The only redeeming thing is that the files are al

I have an Access 2000 database with 14,000 records. Normal size after compact
is 22 mb. Starting Friday, file periodically increases in size by about 50%
even if only one record is added; doesn't happen all the time. It just did it
with only one user in the system. It seems to ...

I have been using access 2000 for a database in which I insert a lot of
images into forms...have never had any problems...just inserting object and
selecting a pic from my picture directory...However all of a sudden all new
pictures are not showing up...All that is showing is the ...