I have a quite large Access db with about 6,000 records,
each with 32 fields divided into three tables. I'm having
a problem with dates in one of my tables, especially since
I'm trying to get the dates listed in chronological order.

I have 2 databases which I would like to merge and make
one database, most of the table fields are the same, as
well as some data is the same, the 2 databases are named
DHA and DHA life, I have imported all tables,queries and

One of my tables suddenly got 60 rows of ### inside of it and the primary
key has lost.
What can cause this error?

I have a table that after there have been several
deletions, the numbers skip, but in order to perform
certain functions, the autonumber needs to be
consecutive.  This primary table is linked to at least 5

I have a very quick question.  I have an Access 2003 database that
generates serial numbers for products using multiple fields (facility,
date, shift, line #, etc).  Included in this serial number is a 4
digit incrementing autonumber called UnitNumber:

Access 2k sp3 on XP Pro
When clicking next after selecting the table and fields
for my lookup table I get the error:
Automation Error

I know they are rare; but say you have a "is married to" relationship between two instances of a tblPERSON.  I have a PersonID and Spouse attributes in tblPERSON.  In Relationship view of Access, I cannot drag PersonID to Spouse to form a relationship
My workaround is to add ...

My problem is when trying to insert and embed, as opposed to link, a graphic
into a table as a bmp.  I am developing an access database which has photos
of clients.
When I choose the object type, created from a file I get he following error

When I import data to my table, the macro generates an
error table that lists the records that contained
errors.  All the data in all the fields does import.  The
errors occur on the Description field, which is a memo

In the last stage of File Normalization process. I want to
change my primary field to another field that will allow
duplicates. But a message appears:
Removing or changing the index for this field would

How can you autonumber records in a query?

I have an Access 2000 database that is shared on a Novell server among about 20 Win2000/AccessXP users, each of whom has a copy of the front-end on his or her own machine.
To ensure that the users are working with the most up-to-date version of the front-end, I've recently given ...

I have an office program at home and one at my office, I
would like to combine the two databases.
How can I do that
Thanks for the help

How can I query an @ sign that's in a data base?

Please what is the database limit as in number of records
for access