I just want to compact the current database as done when I use the
menu point to compact and repair a database. How can I accomplish
this?
Currently I find mthods only to compact other databases, but not the

I've recently converted an Access97 file to Access2003.   During the
conversion, there were "compilation errors" due to old DAO syntax no
longer supported.
I hired an Access programer to fiddle with the code and he got it

I have an Access 2000 application (MDB) with many forms. Each form as a VBA
module behind it. Over the past year or so, I experience a problem with one
specific form. Every once in awhile, if I make a change to the form or the
VBA code behind the form, when I go to run the ...

I'm trying out using recordsets for the first time, and I'm having a couple
of problems with the syntax in runtime.
The code is
Dim db As Database

How can I get the information displayed in the database properties dialog
contents using VBA code?

I am getting a errror of mismatching type in a SQL.
My searchinf field is long interger (primary key) and I couldn't find how to
pass it as numeric variable to the SQL statement. It is assuming always
assuming it as text.

Is there any way with the following logic to set the following attributes for
this fields: Required, Allow Zero Length, Indexed, Format
   Dim MyDatabase As Database, NewTable As TableDef
   Set MyDatabase = DBEngine.Workspaces(0).Databases(0)

How would I change a text field size from 2 to 20 using VBA
thanks
Nigel

The following code is attached to the OnNotInList Event of a combo box
that I have. The idea behind the code is to check wether or not the
value entered exists in a field DIFFERENT from the bound filed of the
combo box. The idea is that if I want to select DAVID C. HOLLEY, I can

I need to change which controls are displayed if the user is on a new
record. I'm trying to use the isNewRecord() function to handle this,
however the function is not detecting that the user has moved to a new
record when I click on the NEW RECORD navigation button.

How can I integrate using Access XP VBA into being accepted by Access 97?
Some people work in XP others are still in "97".

I am creating a database to schedule training for a team of around 60 people.
There are also about 60 training courses, some of which are prerequisite to
others. I want to set up something which gives an error message if you
attempt to schedule training for an individual but they ...

We have several apps that were written in Access and every two weeks, we have
to archive our databases based on certain dates.  I was wondering if anyone
was aware of a way to automate this process?  If so your help would be
greatly appreciated.  

At the end of the year i want the user to press a button, and it will take
the records out of the table and reset the autonumber file to #1, but i
haven't been able to do it.  Because one of the tables has to have one
beginning record in it i thought i would create a dummy table ...

I was wondering if anyone here could asssit me on this?  I have a program
that allows the user to download about 8 different tables then upload them on
laptop or tabletPC.  Also, the reverse is true as well.  Each tabletPC or
laptop downloads their files and uploads them to the ...