determining type of JET MDB file

[Drew Curry]

I am building a generic compactor for a client, and had this question...

Can we determine the type of MDB file in code prior to calls with JRO
for compacting? I searched this newsgroup but did not find much in the
way of this idea. I am aware of needing the correct type for the call to
work, but would like to not force a user to have to select the type
before issuing a Compact command...

thanks, drew..

[Larry Rebich]

Drew:

I don't know what JRO is. I do know that if an 'Access/Jet' database is
compacted with DAO the 'new' database is created with the same version as
the 'old' one.

Cheers,
Larry Rebich

More tips link to:
http://www.buygold.net/tips.html

Please:
No personal e-mail questions :-)


"Drew Curry" <dcurry@no.spamola.home.com> wrote in message
news:MPG.1558a61dc434fada989690@news.devx.com...
> I am building a generic compactor for a client, and had this question...
>
> Can we determine the type of MDB file in code prior to calls with JRO
> for compacting? I searched this newsgroup but did not find much in the
> way of this idea. I am aware of needing the correct type for the call to
> work, but would like to not force a user to have to select the type
> before issuing a Compact command...
>
> thanks, drew..

[Filipo Mór]

Drew Curry <dcurry@no.spamola.home.com> wrote:
>I am building a generic compactor for a client, and had this question...
>
>Can we determine the type of MDB file in code prior to calls with JRO
>for compacting? I searched this newsgroup but did not find much in the
>way of this idea. I am aware of needing the correct type for the call to

>work, but would like to not force a user to have to select the type
>before issuing a Compact command...
>
>thanks, drew..

Hi, Drew!

I'm not sure about what does 'MDB type' means. What exactly do you want
to know? The MDB version (1.0, 1.1, 2.0, etc)? Or what? Give us more information,
ok? :-)

tks!

Filipo

[Drew Curry]

Hey guys, what i meant was that if a user selects an MDB file for
compacting (using MS's JRO object: Microsoft Jet and Replication Objects
2.5 Library), can we then run an api call or similar to determine which
version the mdb file is in?

The reason i ask is that we must include the version indicator in the
JRO call in order to correctly compact it. I have various systems at my
client's offices and some older tools use JET 3.51 mdb's and some use
Jet4.0..

thanks, I hope this clears it up! drew..

In article <3af04586$1@news.devx.com>, fmor@terra.com.br says...
>
> Drew Curry <dcurry@no.spamola.home.com> wrote:
> >I am building a generic compactor for a client, and had this question...
> >
> >Can we determine the type of MDB file in code prior to calls with JRO
> >for compacting? I searched this newsgroup but did not find much in the
> >way of this idea. I am aware of needing the correct type for the call to
>
> >work, but would like to not force a user to have to select the type
> >before issuing a Compact command...
> >
> >thanks, drew..
>
> Hi, Drew!
>
> I'm not sure about what does 'MDB type' means. What exactly do you want
> to know? The MDB version (1.0, 1.1, 2.0, etc)? Or what? Give us more information,
> ok? :-)
>
> tks!
>
> Filipo
>
>