Access 2003 file format

[Daven Thrice]

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

[Matthias Klaey]

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

[Tony Toews]

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

[Daven Thrice]

"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 :-)

[John Baker]

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

[Tony Toews]

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

[Trevor Best]

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

[Daven Thrice]

"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.

[Trevor Best]

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

[Darryl Kerkeslager]

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.

[Duane Phillips]

"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.