Convert Access 2000 to 2003?

ExpandCollapse

Guest

I just created a new database in Access 2003 and when I went to make an MDE
file for the users I got the following error message.

You cannot create a MDE file from a database saved in 2000 format.
Convert the database to the current version. Then create the ADE or MDE
file.

I have no idea why when creating a new database in Access 2003 it uses the
Access 2000 format, but how do I now convert this database to the Access
2003 format so I can create the MDE file? I created the backend also in 2000
format without realizing it and I have it connected to a secure workgroup.
Any help or suggestions would be greatly appreciated.

ExpandCollapse

Guest

On Tue, 18 Jul 2006 11:39:53 -0400, Roger Tregelles wrote:
> Hi Folks,
>
> I just created a new database in Access 2003 and when I went to make an MDE
> file for the users I got the following error message.
>
> You cannot create a MDE file from a database saved in 2000 format.
> Convert the database to the current version. Then create the ADE or MDE
> file.
>
> I have no idea why when creating a new database in Access 2003 it uses the
> Access 2000 format, but how do I now convert this database to the Access
> 2003 format so I can create the MDE file? I created the backend also in 2000
> format without realizing it and I have it connected to a secure workgroup.
> Any help or suggestions would be greatly appreciated.
>
> Roger Tregelles
> Quality Assurance Engineer

The Access 2000 format is set as the default when you create a new
database. To change it:
Tools + Options + Advanced

ExpandCollapse

Guest

Fred,

Thanks, I totally forgot I could do this in Access from the Tools menu. I've
changed the default format to now be Access 2002-2003 for all new databases.
I really appreciate your quick response and help with this. Take care.

About Us

Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Like us on Facebook

Support SPN

The management works very hard to make sure the community is running the best software, best designs, and all the other bells and whistles. We'd really appreciate your support!