I moved a existing database from foxpro to access 2000.  
The dates in foxpro had a 2 digit year and when brought in
to access it converted them to 1900 (eg. 11/12/00 to
11/12/1900 instead of 11/12/2000).  Is there a way in

I'm trying to import a text file containing some German characters to Access97, and the German characters seem to get lost. For example, if I have a simple file containing word 'Süd' when imported, it changes to 'Snd'
This works correctly in Access2000
Any help would be appreciated ...

I'm using Access '97
What are the relevant functions in Access that correspond to Upper, Lower
and Proper in Excel?  I am trying to compare and integrate data from two
sources but all of the name and contact information in one source is in

When I attempt to use the [Tools];[Database Utility]; to
[Convert Database]; to Access 2000 format from Access XP,
the resulting database doesn't display anything in the
Detail View.  All tables and queries appear to be present

I have 3 versions of Access on my developer machine (97,
2000 and XP).  All were working fine until today.
While working in an XP project, Access bombed.  It
indicated I should look for updates, which I did.  The

Whenever I copy a section in Word (for Windows), Word often feels compelled to change my formatting.  I.E. I copy a section of text that is font size 11, times new roman, italicized, and move it to another section.  Suddenly, the font size is 12 and has gone bold.  Any ...

With Access 2002, how do you calculate the time
difference into hr:min or just minutes?  For example,
from Dec 21st 2002, 0200h till Dec 21st 2002, 0315h.  And
between Jan 2nd 2004 2300h till Jan 3rd 2004 0110h.

I recently converted over from a Mac to Windows.  I had
several spreadsheet documents that I converted using
Maclink.  They converted over okay.  But, when I try to
use them, and then wanted to save them, I have to save in

When I convert a Access 97 report to Word 97, some of the
memo fields truncate in Word.  It does not matter the size
of the data in the memo field.  Sometimes the data is a
only a few sentices, other times a large paragraph.  Other

I have converted two Access 97 database to Access 2003. In both cases when I open the converted database in Access 2003 my code stops every time I reference a field on a form using the Me.FieldName syntax. For example if I am setting a string variable called strFName to be equal ...

I am wondering if Access has a similar ability to MS Project: Whereby
tasks(Project) or rows(Access) can be e-mailed from within Access, the
recipient can update fields from their in-box(no need for a copy of
Acess here,) return the email, and have the database automatically

I have several MS Works wdb files that I need to convert
to MS Access mdb files.
Works can convert wdb files to csv, txt, or dbf files.
Access can open only mdb, mda, mdw, and mde files.

dear,
I'm back in access dev for a while ...
I know that on PC it was possible to execute a .mdb on a machine without MS
Acces

I am importing/linking spreadsheets into a ms access(2000) database.
However, the format of the data of the columns I intend to join on
needs massaging first!
For instance:

I have developed a number of applications in Office/Access
97 that now need to upgraded to Office XP in parts. I say
in parts due to the fact that part of the organization
still runs Office 97 and the other runs Office XP. I've