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

Access 2003 file format

P: n/a
If I create an mdb in Access 2003, in 2003 format, and go to a computer that
has Access 2002 on it, will I be able to open and edit all of the objects?

Thanks,

dt
Nov 13 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
On Sat, 20 Nov 2004 09:55:35 -0800, "Daven Thrice"
<da*********@NOyahooSPAM.com> wrote:
If I create an mdb in Access 2003, in 2003 format, and go to a computer that
has Access 2002 on it, will I be able to open and edit all of the objects?

Thanks,

dt


There is no new file format for Access 2003, it is the same as Access
2002, so you should not have any problems, as long as you do not use
any features that are new in Access 2003 and not contained in Access
2002.

HTH
Matthias Kläy
--
www.kcc.ch
Nov 13 '05 #2

P: n/a
Matthias Klaey <mp**@hotmail.com> wrote:
If I create an mdb in Access 2003, in 2003 format, and go to a computer that
has Access 2002 on it, will I be able to open and edit all of the objects?

There is no new file format for Access 2003, it is the same as Access
2002, so you should not have any problems, as long as you do not use
any features that are new in Access 2003 and not contained in Access
2002.


Except if you open an A2003 MDE in A2002 you will get a cryptic "VBA is corrupt"
message.

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

P: n/a

"Tony Toews" <tt****@telusplanet.net> wrote in message
news:pu********************************@4ax.com...
Matthias Klaey <mp**@hotmail.com> wrote:
If I create an mdb in Access 2003, in 2003 format, and go to a computer
that
has Access 2002 on it, will I be able to open and edit all of the
objects?

There is no new file format for Access 2003, it is the same as Access
2002, so you should not have any problems, as long as you do not use
any features that are new in Access 2003 and not contained in Access
2002.


Except if you open an A2003 MDE in A2002 you will get a cryptic "VBA is
corrupt"


Ahhh.... let the truth be told :-)
Nov 13 '05 #4

P: n/a
Tony:

Does that require any action in order to run macros and VBA then?

I have found a good principal is to develop on the earliest version that will be used in
running the application (if you can figure that out)! Right now I am developing almost
everything on the Office 2000 platform, although that does not give all the bells and
whistles that are now available I am pretty certain it will work for later versions.

Best

John Baker

Tony Toews <tt****@telusplanet.net> wrote:
Matthias Klaey <mp**@hotmail.com> wrote:
If I create an mdb in Access 2003, in 2003 format, and go to a computer that
has Access 2002 on it, will I be able to open and edit all of the objects?

There is no new file format for Access 2003, it is the same as Access
2002, so you should not have any problems, as long as you do not use
any features that are new in Access 2003 and not contained in Access
2002.


Except if you open an A2003 MDE in A2002 you will get a cryptic "VBA is corrupt"
message.

Tony


Nov 13 '05 #5

P: n/a
John Baker <Ba******@Verizon.net> wrote:
Does that require any action in order to run macros and VBA then?
Macros would work but if the A2003 MDE had any VBA code at all then it won't run in
A2000 or A2000.
I have found a good principal is to develop on the earliest version that will be used in
running the application (if you can figure that out)! Right now I am developing almost
everything on the Office 2000 platform, although that does not give all the bells and
whistles that are now available I am pretty certain it will work for later versions.


AFAIK A2000 MDEs work just fine in A2002 and A2003.

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

P: n/a
Tony Toews wrote:
John Baker <Ba******@Verizon.net> wrote:

Does that require any action in order to run macros and VBA then?

Macros would work but if the A2003 MDE had any VBA code at all then it won't run in
A2000 or A2000.

I have found a good principal is to develop on the earliest version that will be used in
running the application (if you can figure that out)! Right now I am developing almost
everything on the Office 2000 platform, although that does not give all the bells and
whistles that are now available I am pretty certain it will work for later versions.

AFAIK A2000 MDEs work just fine in A2002 and A2003.


But you need A2K to create them? :-)

--
This sig left intentionally blank
Nov 13 '05 #7

P: n/a

"Trevor Best" <no****@besty.org.uk> wrote in message
news:41**********************@news.zen.co.uk...
Tony Toews wrote:
John Baker <Ba******@Verizon.net> wrote:

Does that require any action in order to run macros and VBA then?

Macros would work but if the A2003 MDE had any VBA code at all then it
won't run in
A2000 or A2000.

I have found a good principal is to develop on the earliest version that
will be used in
running the application (if you can figure that out)! Right now I am
developing almost
everything on the Office 2000 platform, although that does not give all
the bells and
whistles that are now available I am pretty certain it will work for
later versions.

AFAIK A2000 MDEs work just fine in A2002 and A2003.


But you need A2K to create them? :-)


In A2002, you can save the mdb in 2000 format.

Nov 13 '05 #8

P: n/a
Daven Thrice wrote:

AFAIK A2000 MDEs work just fine in A2002 and A2003.


But you need A2K to create them? :-)

In A2002, you can save the mdb in 2000 format.


But you need A2K to create an MDE (not MDB) from it.

--
This sig left intentionally blank
Nov 13 '05 #9

P: n/a
Correct. A2002 will not let you create an A2000 MDE, only an A2000 MDB.
Darryl Kerkeslager
"Trevor Best" <no****@besty.org.uk> wrote:
AFAIK A2000 MDEs work just fine in A2002 and A2003.
But you need A2K to create them? :-)

In A2002, you can save the mdb in 2000 format.

But you need A2K to create an MDE (not MDB) from it.

Nov 13 '05 #10

P: n/a

"Tony Toews" <tt****@telusplanet.net> wrote in message
news:pu********************************@4ax.com...
Matthias Klaey <mp**@hotmail.com> wrote:
If I create an mdb in Access 2003, in 2003 format, and go to a computer
that
has Access 2002 on it, will I be able to open and edit all of the
objects?

There is no new file format for Access 2003, it is the same as Access
2002, so you should not have any problems, as long as you do not use
any features that are new in Access 2003 and not contained in Access
2002.


Except if you open an A2003 MDE in A2002 you will get a cryptic "VBA is
corrupt"
message.

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


I also experienced this with an ade created in 2003, but used with 2002
runtime. So I send the file to, and compact/repair and make ade on a 2002
dev version. I attempt the creation of the ade twice... I don't yet know
why, but the second attempt to make the ade works fine, and the first never
does.

~ Duane Phillips.
Nov 13 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.