How do convert database files in Microsoft Works to
database files in Access 2003?

In Access 2000 I was able to import from Foxpro, under
the option of File Type being ODBC and then the tab for
Machine Data sources.  This option set is not present in
Access 2003, and I cannot load Access 2000 on my new XP-

In my Access database, I have one "TEXT" field which
contains date in "mm/dd/yy" format & now
1> I want to convert the Text data in actual Date
(MM/DD/YY) format

Have just put a database written under access 97 on a machine with
2003. I got an initial warning message about "unsafe expressions not
being blocked" which sugessted I needed to load Jet 4 servicepack 8,
which I did. That sorted that but I now get a "this file may not be

I need to know how to create a table with the 'decimal' data type in MS
Access , via the create table statement. using
create table testtable(testcol decimal(10,2) null)
obviously doesn't work.

We are trying to import data from an excel spreadsheet
into Access.  We are having difficulty with a date field
from the Excel spreadsheet terminating the import with a
generic error message.  I have tried several datatypes at

Converted an Access 97 database to Access 2000 about a
month ago.  It is used by about 30 people 24/7.  There
have been 2 instances since then, where 'there was an
error executing the command' comes up trying to update

I had to reformat the hard drive on my laptop and reinstall everything. When
I open my main database, I get the following error:
The database is in an unexpected state. MSAccess can't open it. The database
has been converted from a prior version of Access by using DAO compact