By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,589 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

A2003 App in A2000?

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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****@antarctic.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

Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
Tim Marshall <TI****@antarctic.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
Nov 13 '05 #4

P: n/a
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
Nov 13 '05 #5

P: n/a
Also:

?syscmd(acSysCmdAccessVer)
9.0
?application.DBEngine.Version
3.6
?application.ProductCode
{00000409-78E1-11D2-B60F-006097C998E7}

(david)
"Tim Marshall" <TI****@antarctic.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

Nov 13 '05 #6

P: n/a
Also:

?syscmd(acSysCmdAccessVer)
9.0
?application.DBEngine.Version
3.6
?application.ProductCode
{00000409-78E1-11D2-B60F-006097C998E7}

(david)
"Tim Marshall" <TI****@antarctic.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

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.