A2003 App in A2000?

[Tim Marshall]

This is for a personal "fun" application I've been toying with for years
first in A97, now in A2003. It's just for me and my friends who
aprticipate in a weird hobby to use. My friends have A2000, but none
have A2003.

I know I can't give them an mde, but are there any pitfalls to
developing in 2003 and giving a 2003 mdb to a machine with 2000?

I'm thinking of putting in a routine to check for Jet version (not sure
what version of Jet 2000 has versus 2003), but are there things like
functions that behave or do things differently in 2003 that may not work
in 2000?

Thanks very much in advance.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Wayne Morgan]

Access 2000 uses the same version of Jet as 2003. Also, the default file
format for 2002 (XP) and 2003 is the 2000 file format. As long as you don't
use any new functionality or commands from the 2002 or 2003 versions, you
should be in good shape. To find these, check What's New in the help file
from Access 2002's and 2003's VBA Editor window. You will also find some
information here.

http://office.microsoft.com/en-us/as...817081033.aspx

--
Wayne Morgan
MS Access MVP
"Tim Marshall" <TI****@antarct ic.flowerpots> wrote in message
news:cp******** **@coranto.ucs. mun.ca...

This is for a personal "fun" application I've been toying with for years
first in A97, now in A2003. It's just for me and my friends who
aprticipate in a weird hobby to use. My friends have A2000, but none have
A2003.

I know I can't give them an mde, but are there any pitfalls to developing
in 2003 and giving a 2003 mdb to a machine with 2000?

I'm thinking of putting in a routine to check for Jet version (not sure
what version of Jet 2000 has versus 2003), but are there things like
functions that behave or do things differently in 2003 that may not work
in 2000?

Thanks very much in advance.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Tim Marshall]

Wayne Morgan wrote:

To find these, check What's New in the help file
from Access 2002's and 2003's VBA Editor window. You will also find some
information here.

http://office.microsoft.com/en-us/as...817081033.aspx

Thanks Wayne.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Tony Toews]

Tim Marshall <TI****@antarct ic.flowerpots> wrote:

I'm thinking of putting in a routine to check for Jet version (not sure
what version of Jet 2000 has versus 2003

Excellent idea.

What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the Verify Appropriate Jet Service Pack is installed page at my
website for more details including sample code:
www.granite.ab.ca\access\verifyjetsp.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Tim Marshall]

Tony Toews wrote:

What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the Verify Appropriate Jet Service Pack is installed page at my
website for more details including sample code:
www.granite.ab.ca\access\verifyjetsp.htm

I'll take a good look at this, Tony, thanks.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[david epsom dot com dot au]

Also:

?syscmd(acSysCm dAccessVer)
9.0
?application.DB Engine.Version
3.6
?application.Pr oductCode
{00000409-78E1-11D2-B60F-006097C998E7}

(david)
"Tim Marshall" <TI****@antarct ic.flowerpots> wrote in message
news:cp******** **@coranto.ucs. mun.ca...

This is for a personal "fun" application I've been toying with for years
first in A97, now in A2003. It's just for me and my friends who
aprticipate in a weird hobby to use. My friends have A2000, but none
have A2003.

I know I can't give them an mde, but are there any pitfalls to
developing in 2003 and giving a 2003 mdb to a machine with 2000?

I'm thinking of putting in a routine to check for Jet version (not sure
what version of Jet 2000 has versus 2003), but are there things like
functions that behave or do things differently in 2003 that may not work
in 2000?

Thanks very much in advance.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[david epsom dot com dot au]

Also:

?syscmd(acSysCm dAccessVer)
9.0
?application.DB Engine.Version
3.6
?application.Pr oductCode
{00000409-78E1-11D2-B60F-006097C998E7}

(david)
"Tim Marshall" <TI****@antarct ic.flowerpots> wrote in message
news:cp******** **@coranto.ucs. mun.ca...

This is for a personal "fun" application I've been toying with for years
first in A97, now in A2003. It's just for me and my friends who
aprticipate in a weird hobby to use. My friends have A2000, but none
have A2003.

I know I can't give them an mde, but are there any pitfalls to
developing in 2003 and giving a 2003 mdb to a machine with 2000?

I'm thinking of putting in a routine to check for Jet version (not sure
what version of Jet 2000 has versus 2003), but are there things like
functions that behave or do things differently in 2003 that may not work
in 2000?

Thanks very much in advance.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto