I am taking an access 2002 course which includes a CD with
2002 databases. I have version 2000 at home and at the
office.  Is there any way to open these databases?  Or do
I have to upgrade to 2002?

I have an mdb front end and back end.  Will the same DAO code work if I link
my mdb front end to a SQL Server, or do I have to make my code ADO-compliant
as if I were converting my front end to an access project (i.e., ADP)?
With that in mind, is "Forms!Formname.Form.RecordsetClone ...

I have a database in Access 2002 at work. I need to use it
also on my Pc which only has Access 97 and I can't upgrade
it.
Is it possible to copy the data backward and forwar or do

We have a db which we converted from 2000 to 2002 and
then edited a query. It then shutdown Access and left
the .ldb file. Is there a problem editing queries created
in earlier versions of Access?

good day!
May i know the procedures on how to make access file to an
executable file.  I read a lot of Access books from 97 to
XP versions but i was not able to find any.

I left the office without leaving a message on my email
that I would be out of the office. Could someone tell me
how to put this on my email from home? I do not have the
chose of ACTIONS, as I would if I was in the office.

How can one accomplish this?

Does ADO only work with adp files?   I'm trying to convert some real simple
DAO to ADO and it's not working.    I"m working with an mdb file, in v2000
on NT and 2003 on XP, mdb backend.   I have all the proper references (could
the order be wrong?).  It involves searching for a ...

I have installed the converter for moving from Access 2.0
to Access 2003 running under Windows XP Professional.
However Access 2003 still tells me I need to convert the
database and does not recognise the converter has been

Can anyone point me to any web resources on known Access97
to Access 2000 conversion issues?.
Is there a 97 - 2000 conversion toolkit application such
as the one that exists for A2003?.

I have a small application with 1 form, 1 table and 2 query.  The form is the
startup object and it calls query 1 which deletes all rows in a table and
then calls query 2 which read an AS/400 table and fills the access table.  
The application is run with access runtime and not ...

I recently converted a Access 2000 application to 2002 Format.  I then
discovered that all my default values for Date () had stopped working.  I've
tried clearing the defaults and reentering them, as well as going back to
2000 and reconverting.  Neither helped.  Each time, the ...

What utilities, i.e. modules, do I absolutely need to run the database in a
multi-user environment?   I plan on upsizing my Access 2003 database to SQL,
but keeping my front end as an mdb file, and since DAO can be a b*t*h to
convert to ADO, will just strip it out and put it back in ...

I have two database applications developed in Access 2000
on a Windows 2000 workstation. I tried to move them to a
XP workstation which has Access 2003 since all of our
workstations are required to upgrade to XP. I copied the

I am importing a Dbase III table into MS Access,  All of
the text fields are in uppercase (Approximately 17,000
records).  My question is how can I convert all of the
text fields to lower case with only the first letter of