Hi Raj,
AFAIK you won't be able to use an Access 2000 database with Access 2.
It appears from Help that it's possible to convert an Accesss 2000 mdb
file to Access 2 format by using the DAO CompactDatabase method with the
dbVersion20 constant. Presumably you would first need to ensure that
none of the tables or queries in the mdb use any features introduced
since Access 2 (e.g. decimal field type, some SQL syntax). In addition
there could be code page issues with the conversion from Unicode in
Access 2000 to 1-byte text in the older version.
I doubt whether forms, reports or modules would convert this way, but
the data probably will.
If the above approach doesn't work, try creating a new Access 2 mdb and
then exporting the tables from the Access 2000 mdb to it.
create a new database (mdb file)
I have a unique problem. I have a Database in Access
2000, and I need to use it under Access 2.0 and ensure
nothing is lost in translation. I am trying to import
Access 2000 to Excel 2.1 ad then to Access 2.0
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
