I have a database that I have been using for years.  I installed some updates
and now I get a "invalid argument" error when I try to open the database.  I
have tried to run the "compact and repair" program within access, but I just
get the same error.  Does anyone have any ideas?

I have two databases, db1 and db2, with the same table, TableA. I want to
select the records from TableA in db1 that have a LAST_UPDATE > SomeDate.
Then I want to get the identical records in TableA from db2. However the
LAST_UPDATE dates will be different between db1 and db2. ...

I have a form where I enter a line number that may or may not match the
primary key in another table. My question is how do I go about
populating some fields in my form when the record exists in the table?
I was thinking a dlookup but am unfamiliar whith this function and was

I'am trying to send automatic elmails from ac2000 with a click on a form. I
use Outlook because i need to send an attachement with. The first time i'll
send an email there is no problem, but the next time occurs a problem, eg
there is  no longer reaction in access, the screen is ...

I need to create a form that is a giant calendar.
For each day of the month (users should be able to browse the months)
the date is a different color if:
1) The daily routine ran

I have a generic form to keep data. I.e, date, number, string all are
stored as TEXT in different rows in a same table.
i would like to validate that the date is in a correct format. The
different rows appear in the 'Detailed" section. May i know how do i

I'm using DIR to loop through files in a folder and it's working fine.
But can I control the order of the looping.  For example, the first
file would be the file with the most recent Date Modified or
vice-versa.  Or what if I want to loop through the files based on

Is there a way to set up access to open and run a query in a particular
database at a particular time each day?  This would be run from a
Windows 2000 desktop.

I encountered this problem for the first time today while trying to add
some columns to a query from a linked DBASEIII file.  The new columns
that I added on the design grid do not show up on the data sheet, even
though the box is checked.  I've already done some trouble shooting,

I have a table called EMPLOYEES with the following fields:
EmployeeID
LastName
FirstName

If you develop for others, you probably have multiple versions of Access
installed so you can edit and create MDEs for clients in different versions.
This works fine under Windows XP, even with Access 2007 installed.
It does *not* work under Windows Vista Ultimate. After running ...

WatchOut for "Allow AutoCorrect" in your unbound combobox lookups.
I am building a personnel database, and the last name of Ballance was
causing the following message to popup, prohibiting me from selecting
the record:

I have a parameterised query for a report like this;
PARAMETERS Event_ID Short;
SELECT DISTINCTROW Events.[Event ID], ...
FROM Events

Hi, hoping someone can help.
The situation is that an app I designed is installed on a desktop PC and six
laptops,separately, which synchronise to the desktop once a day at random
times.

I am trying to add a cmdButton to an Access form.  I would like to
click the button, look up an email address in a database table, and
execute Outlook with that email address ready to send an email.
Has anyone tried this?