I have an overnight batch file that run an access DB (name it
AG_Import.MDB).  AG_Import.MDB import data into a secured back-end DB
(AG_be.MDB).
If I run it manually, I use:

I want to have my database automatically do the something like
the following every week:
DBEngine.CompactDatabase path2sourcefile, path2newfile
Me.Application.CompactRepair path2sourcefile, path2newfile

I have an existing table with two fields in it (Code and Description) that I
want to use to fill a field in a new database table using an Input Form.  I
would like the user to see the Description field values in the pop-down list
and, based on their selection, have the Code field be ...

Can anyone help me with an "Automation Error" I am receiving in Access
XP?  I am using the Combo Box wizard to create a combo box on a simple
form and receive the following error "Automation Error.  The specified
procedure could not be found."  I get this error right after I select

Surely this was possible in Access 97. Has it gone or am I just not
seeing the wood from the trees. Any help Grateful.
Regards

I'm running Access 97 on Windows 98. I need to make large tables and
queries with approaching but not exceeding 225 fields (columns). Access
is giving me a "too many fields" message when I try to save the table or
query although there are fewer than 255 fields. Sometimes it works ...

Not sure if this is possible, but can I change the controls of a
command button on a per record bases in a subform. In my case, I would
like to make a command button visible only if certain fields in a table
are a certain value. The buttons are adjacent to each record (i.e. - if

I have 2 tables (tblSAPDetails & tblVendorDetails) they both have
Vendor as the PK. I would like to run a query which would highligh the
differences between the 2 tables on 2 fields (ABC and Industry)
Eg:

I put a new record button on a form and I get a message that "you can
not go to that record"
Would someone tell me what is wrong.  I put buttons on both the parent
and child tables that go to first record, previous record, next record,

I'm using Access 97, I have a problem with my form.  I have a subform
inside my form.  I would like to diable the subform if submission
number is 1 and enable it if it is greater than 1.  I will only use the
subform if submission number is greater than 1. or make it a subform a

ok i have a problem here and not much time to play round.
have a form bound to a table. one of the combos is bound to a field
Agents. i have active and retired agents. thing is, i want to be able
to retrieve all agents from the table, but to see only active in

I'd like to do this:
Have a SQL Server database hosted on a public facing web server.
I want it to be held at an ISP/Web hosting company. Though I have ADSL here
I don't want to manage a server.

What is the report function in Access 97 that allows you to zoom to a
specific size? ie.125%
Not the Minimize or Maximize function.

i created a form in outlook 2000 hoping that i can populate with data
stored in access 2000. however, i don't know the steps to populate the
outlook form!?  any advise or direction to specific websites would be
appreciated!

So I think this may be a stretch, but I have a subform that is
displayed on a main form.  The subform is based on a query that brings
records from a table(It does not bring all fields, but the main
identifiers, since there would be too many to be able to display).  The