I moved all tables/queries/macros/forms from Access97 to Access2000, when I
ran the compact repair tool, it gave me a compile error in the line
DIM dbs as database
What should I do?

Is there a way to programmicly tell the difference between an Access 97 and
an Access 2003 database without opening the database?
If so how?

I have a form that I want to use to update information in a table. I've
decided to use checkboxes to make it as simple and easy to use as possible. I
want to use two of the checkboxes as an either/or kinda thing. Something like
this:

I am trying to rewrite a database from an older version of Access to Access
2000. VBA is still fairly new to me and there is a single line of code that
is giving me a problem.
Set accrual = DBEngine.Workspaces(0).OpenDatabase("p:gautam\tables.mdb")

I have written a function that I am calling from a query to calculate what I
call a "precision index" (PI).  I have recordsets of different sizes, but I
only want to calculate a PI on recordsets with a record count of 3.
I have tried inserting code to the effect of:

My understanding is that when you create an Excel object, the correct way to
cause the instance of Excel (in Task Manager Process) is to quit the
application and set the object variable to Nothing.
You will not in my code below that I am doing that.  Note that this code is

Okay,
Age old problem... Looking for the latest date in a table.
Our team has come up with 2 methods... Both work, but there is debate on
which is more efficient/preferable.

My Name is Hermann. I have tried to find a solution for default values
in an Access program I have made to organize the daily management of
the vessel.
I have tried this method. I found your comment in internet Google

I'm trying to connect to a dbf file from a visual basic function (in a module
in access) to get some data and copy it in an access table...
I can't use ODBC, i must get the dbf file from a common dialog, connect to
it, get the data and close it.

I have developed a module in MS access 97, which is called from a form.
Everything seems to work fine, but when I close the database, I am not able
to quit Access. Access is minimized, but the database is closed.
If I add a MsgBox instruction in the module, everything works ok. ...

Is it possible to programme a procedure which allows users to browse for
linked files at run time.  I have an application which uses Microsoft Access
Developer Extensions to distribute run time access applications to users who
do not have the access to the Linked Table Manager.

I have a VBA code which allows me to send a new email using Lotus Notes from
an MS Access form - the code is behind a button.
I am after help on editing this code so that the email is automatically
addressed to a specific field in the form. I have a field called "email"

Assume a folder structure of C:\Test, which contains a subfolder called "ABC"
In the C:\Test folder, I have an Access db with a VBA module in it.  In the
C:\Test\ABC subfolder I have a number of .csv files.
Can someone tell me what flaw in my logic (or my VBA skills) causes the

I need to WinZip a file from within VBA.
From other posts I see a bat file with:
start wzzip -u "G:\MySpace\MyZip" "G:\DbArea\*.*"
Do I just simply place this line (with my directories of curse) in a bat

I'm trying to send an email from Access through Outlook (both XP).
The issue is that I'm getting two blank emails brought to the screen, one
addressed correctly (from the code), and the other one blank. Needless to
say, I only want the correct one.