Checking which version of Jet a database is using

[Mystery]

How do I tell which version of Jet particular Access 2000 database is using?
I'm trying to use the proper OLE-DB settings to access it via ASP and
according to [url]www.able-consulting.com[/url] :-

"Note, remember to convert both the MDB and the MDW to the 4.0
database format when using the 4.0 OLE DB Provider"

How do I convert a database ????

Cheers.

[Bob Barrows]

Mystery wrote:

> How do I tell which version of Jet particular Access 2000 database is
> using? I'm trying to use the proper OLE-DB settings to access it via
> ASP and according to [url]www.able-consulting.com[/url] :-
>
> "Note, remember to convert both the MDB and the MDW to the 4.0
> database format when using the 4.0 OLE DB Provider"
>
> How do I convert a database ????
>
> Cheers.

If the database was created with Access 2000, then it is Jet 4.0. If it was
created with an earlier version of Access, then it can be converted using
the Convert Database option in Tools|Database Utilities.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Mystery]

Thanks Bob. Appreciate the quick response

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23Wam3RPwDHA.1760@TK2MSFTNGP10.phx.gbl...

> Mystery wrote:

> > How do I tell which version of Jet particular Access 2000 database is
> > using? I'm trying to use the proper OLE-DB settings to access it via
> > ASP and according to [url]www.able-consulting.com[/url] :-
> >
> > "Note, remember to convert both the MDB and the MDW to the 4.0
> > database format when using the 4.0 OLE DB Provider"
> >
> > How do I convert a database ????
> >
> > Cheers.

>
> If the database was created with Access 2000, then it is Jet 4.0. If it

was

> created with an earlier version of Access, then it can be converted using
> the Convert Database option in Tools|Database Utilities.
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>