convert Access 2000/2002 to Access 95/97

[Sanjib Biswas]

Hi All,

I have written a software that converts MDB->XML->MDB. Everything is
working fine, except the problem is that the Access database needs to be in
"Access 95/97" format, where as currently its in "Access 2000/2002". The
main reason, I need this to be in "Access 95/97" format is because the mdb
files are used by a proprietary software that can only understand "Access
95/97" file format.

Any idea how to create or convert to "Access 95/97" files?

Regards
Sanjib

 

[Sanjib Biswas]

replying to my own post....

I should have looked more closely at DAO before sending this email. I was
using ADOX.Catalog() before. After a few trial with DatabaseTypeEnum, got
the answer.

db = dbe.CreateDatabase(name, LanguageConstants.dbLangGeneral,
DatabaseTypeEnum.dbVersion30)

 

[Mary Chipman [MSFT]]

Have you tried creating a new mdb in that format and importing the
tables and data? If that didn't work for some reason, you should post
the question on the Access newsgroups, where you are more likely to
get a response to your question.

--Mary