473,405 Members | 2,349 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Create Access 2000 MDB from Access 2003

I have upgraded my computer to Access 2003, but I have not converted my
databases since all of my clients still use Access 2000. I need to
create a new MDB, but Access is telling me that I will have to convert
the database to 2003 before it will make an MDB. What are my options?
If I convert the database, I assume that Access 2000 and A2k runtime
will no longer be able to read the MDE. Can I re-install A2k on my
machine? Is there another option?

Thanks in advance.

Nov 13 '05 #1
3 2482
You can convert it back to A2K format after you build it.

Tools -> Database Utilities -> Convert Database -> To Access
2000 File Format

Kevin
KEMDignam<km******@otsysinc.com> 4/12/2005 7:11:11 AM
I have upgraded my computer to Access 2003, but I have not
converted my
databases since all of my clients still use Access 2000.

Ineed to
create a new MDB, but Access is telling me that I will haveto convert
the database to 2003 before it will make an MDB. What are
my options?
If I convert the database, I assume that Access 2000 and
A2k runtime
will no longer be able to read the MDE. Can I re-install
A2k on my
machine? Is there another option?

Thanks in advance.

Nov 13 '05 #2
Tools | Options allows you to specify "Save in Access 2000 Format" in Access
2003. In fact, that is the default choice. You should not have to convert,
if that is set, to create an Access 2000 MDB with Access 2003.

If, in fact, you mean an Access 2000 MDE, that is not supported. MDEs must
be created in the version of Access to which they apply. That is, you must
use Access 2000 to create an Access 2000 MDE.

Larry Linson
Microsoft Access MVP

"KEMDignam" <km******@otsysinc.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
I have upgraded my computer to Access 2003, but I have not converted my
databases since all of my clients still use Access 2000. I need to
create a new MDB, but Access is telling me that I will have to convert
the database to 2003 before it will make an MDB. What are my options?
If I convert the database, I assume that Access 2000 and A2k runtime
will no longer be able to read the MDE. Can I re-install A2k on my
machine? Is there another option?

Thanks in advance.

Nov 13 '05 #3
Are you talking about mdb's or mde's here ?

The default for Access 2003 is to use the Access2K format for the mdb...
so there won't be no problem here...

The weird thing is that you can't make an Access2k-mde file with Access 2003
So, if you are talking about mde's here you must re-install A2k to make A2k-mde's

If you convert to Access 2003, I think that previous versions can't read this ..

--
Hope this helps
Arno R
"KEMDignam" <km******@otsysinc.com> schreef in bericht news:11**********************@z14g2000cwz.googlegr oups.com...
I have upgraded my computer to Access 2003, but I have not converted my
databases since all of my clients still use Access 2000. I need to
create a new MDB, but Access is telling me that I will have to convert
the database to 2003 before it will make an MDB. What are my options?
If I convert the database, I assume that Access 2000 and A2k runtime
will no longer be able to read the MDE. Can I re-install A2k on my
machine? Is there another option?

Thanks in advance.

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: chicha | last post by:
Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I...
8
by: deko | last post by:
Is it possible to develop an Access app in Access 2003 that will run on Access 2000? Is it just a matter of selecting "Access 2000" from the Default File Format drop down list on the Advanced Tab...
3
by: Susan Bricker | last post by:
I just purchased a new PC that came with MS Office 2003 (Professional Ed.). I opened MS Access 2003 and created a new database but it opened with a "note in the window header bar" that says...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
9
by: Marc Miller | last post by:
Hi all, I have 2 dev. machines, the 1st is Win 2000 with .NET 7.0 and the 2nd is XP Pro with .NET 2003. My Web Server is Win 2000 Server with IIS 5.0. I can create a new project on my test...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
5
by: Ecohouse | last post by:
I'm using VB and an Access 2003. The db was originally created in Access 2000, but the computer had to have things reinstalled and now has Access 2003. So I was wondering if there are any...
3
by: banba_ca | last post by:
When I create a new db from the main Access window or thru Vb (set newdb = ...) I always end up with Access 2000 file format. I would like to get 2002 - 2003 file format. The reason is that when I...
3
by: NEWSGROUPS | last post by:
I am in the midst of trying to convert about 25 Access 2000 to Access 2003. The new environment consists of Office/Access 2003 and Outlook 2003. When converting the back ends I have no problems....
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.