Is it possible to run an Access 2000 database on a PC with only Access97 installed?
I.e. Could you use a Access 2000 runtime ?

I'm using Access to view data from an Oracle 9i database.  When I try
to link an Oracle database, the PC appears to Hang before finally
presenting the list of tables to choose from.  It's a large Oracle
Database (lots of objects) and I know it's pulling every object over to

Last week I saw in a code snippet where you can use the shell32.dll to
use code that will shut down Windows from an Access application.  I
tried this and this worked nicely.
My question:

In the code section of the form that I am working on:
I am trying to obtain records from another table other than the one I
am using as the recordsource for the current form.
In other words, I am attempting to open and access records from the

I have a database that I use to keep track of the sales promotions that we
send to companies.
I normally send a mailing based on a subset of the companies in the database
(found using the query:  QryICTMassDistribution3) , I then use a form and

When I'm writing query statements in Access it adds an N in front of my
strings.  What does this denote?

Hi,this has been bothering me for a while now.  I have 2 MS Access 2000
databases, the real one that everybody uses (in the NT network) and the
one I use to design new stuff.  After I test the new forms on mine, I
import them to the real database so everybody can use it.

I know this is a stupid question but I can't find the answer.
Please tell me where to find reference to this so I can print it out
and staple it to my head..
dim I as integer

Does anyone have an opinion on whether it is better to use DAO or ADO
to design VB backend code for a multi-user database using Access 2000?
Most of the database will reside on a server; I want the clients to be
as thin as possible.

I have a report generated via an ID selection made in a dropdown on a
form. The report filters by an on click event in a preview report
button on the form.  Everything in the report, including subreports,
filters perfectly, with the exception of a running sum DLookup field on

I've got an application that imports records from a text file into a
temporary table. I then want to insert from the temp table into a
master table but only records which are not in there already. The data
has no unique fields so to find a duplicate record each field in the

We are using A97-SR2 and XP.
The problem is (simplified):
- We've got an A97 db (say "a97.mdb") on a file server (say "S").
- Many persons need to access this database at a same time (say "P1", "P2"

My apologies if I am out of topic.
I was wondering if there is a small script, program or web reference that
would explain the syntactical differences between TSQL and Access SQL.
TIA

I need to select the first and the second column of a table. But I
don't know the names of the columns.
Is there any way I can select only the first column from a table
without knowing the columnname ?

I want to be able to offer a time limited version of my database. For
example I do not want the program to be able to run after x ammount of days
have gone by.
Could I create this inside access?