I'm building a db using Access 2003 and just found out
the people that I'm building it for are using 97 -- can I
make this work?

I have an access db that has grown from a small pup into something that
needs to run on a more robust platform.  The powers that be have selected a
SQL application to take the place of this access database, however, they
would like to populate the SQL application with the data that ...

I need to import some Filemaker Pro databases into
Microsoft Access 2002.  The databases belong to a remote
user, and that user is the only one who has Filemaker on
their machine.  I've found ways to export out of Filemaker

How do I change a field which contains a date in a mm-dd-
yyyy format into mmm-yy format.
 For Example:  Ship Month = 03/01/2004
 Convert "Ship Month" value to display "Mar-04"

I'm developing a startup form using access 2002 (but using access 2000 file format) - the form will not open correctly for a user with access 2000.  I think it is due to their reference library 'Microsoft Access 9.0 Object Library' where I'm using 10.0 object library.  I think ...

I was able to convert a Access 2000 ADP file to 2002 format with no errors.
When I went to convert that to an ADE for my users I get the error:
"Microsoft Access was unable to create an ADE database"
There are no VB errors when I compile the project and knowledgebase article

My friend uses something called "Alpha5" for a mailing
list, and they do not have MS Access.  Is there some way
I can take their file and convert it for use on my PC
which has ACCESS?  As I understand it, Alpha5 does have

I (or better Microsoft Access) encountered a problem when
I open an Access 97 database that was already enabled for
Access 2002 but has been changed afterwards with Access 97.
I want to know, if I got it wrong, that it should be

I have a question about connecting access front end to SQL
back end. Has anyone done that? Is it efficent?
If it is efficent and does it help me with access issue
with WAN (wide area network)?

Could someone tell me how to run both Access 97 & Access XP on the same
machine. Home machines have Access XP and work machine has Access 97. I had
this info but misplaced it any help would be greatly appreciated
Jack

I have inherited an Access 97 database which has the dates
in text format eg '20040425'.  Changing the data type in
design view deletes all the records.  Anyone know how I
can convert these dates from text to date without data

What formula or function can be used to convert a person
birthdate to his/her current age.  For example:  01-JAN-98
to 6 years old.

I am currently working on a project to migrate our
systems to Windows XP.  I am a novice with Access and
need steps to assure the smooth conversion of Access 97
databases and other Access database versions we may have

Does anyone know how to convert a Access dB from 2000 to
97?

i have several Access 97 database that are about to be
used under Windows XP Pro with office XP
I dont want the datbases to be converted as they need to
be used under NT which has only 97 installed.