convert Access 2000/2002 to Access 95/97

14 Nov 2005 11:19 AM

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

14 Nov 2005 12:50 PM

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)

Show quote

"Sanjib Biswas" <sanjib.bis***@ieee.org> wrote in message
news:O9zAW1Q6FHA.268@TK2MSFTNGP10.phx.gbl...
> 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
>
>
>
>

14 Nov 2005 1:35 PM

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

On Mon, 14 Nov 2005 22:19:52 +1100, "Sanjib Biswas"
<sanjib.bis***@ieee.org> wrote:

Show quote

>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
>
>
>