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

Access 2003 Default File Format

P: n/a
I have a client who is running several Access 97 databases that I have
written for them. They are about to upgrade to Access 2003. Is the
default file format of Access 2003 still Access 2000 the same as it
was in Access 2002?

I am running Access 2002 at the moment. Is there any reason for
testing purposes etc, for me to purchase Access 2003 if I am going to
recompile the Access 97 mdb files into Access 2000 format mde files
which will be used by the client?

Will Access 2003 run the Access 2000 format mde files exactly as
Access 2002 does or could there be subtle differences that could cause
problems?

I don't want to purchase Access 2003 at the moment if there is no good
reason to do so.

Thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Yes, the 2000 file format is the default in 2003. The 2002 file format is
now the 2002-2003 file format. As far as converting the 97 files, you should
be able to do it in 2002 and 2003 should open them just fine. However, when
you start dealing with MDE files, there can be a problem. I have heard of a
problem going the other direction, using the newer version to create and MDE
for the older version, because the References don't work. If you create an
MDE in Access 2003, it will have a Reference set to "Microsoft Access 11.0
Object Library" and 2002 won't know what to do with this. Since it is an MDE
file, you can't change it. I don't know if this will cause a problem going
your direction.

Since the MDB files should work, you may try making an MDE and see what
happens and if it doesn't work, use the clients 2003 to convert the MDB to
an MDE for the first attempt.

--
Wayne Morgan
Microsoft Access MVP
"Wayne Aprato" <cq*******@volcanomail.com> wrote in message
news:4d*************************@posting.google.co m...
I have a client who is running several Access 97 databases that I have
written for them. They are about to upgrade to Access 2003. Is the
default file format of Access 2003 still Access 2000 the same as it
was in Access 2002?

I am running Access 2002 at the moment. Is there any reason for
testing purposes etc, for me to purchase Access 2003 if I am going to
recompile the Access 97 mdb files into Access 2000 format mde files
which will be used by the client?

Will Access 2003 run the Access 2000 format mde files exactly as
Access 2002 does or could there be subtle differences that could cause
problems?

I don't want to purchase Access 2003 at the moment if there is no good
reason to do so.

Thanks in advance.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.