473,320 Members | 1,817 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,320 software developers and data experts.

Access 2003 with a 2000 database

Does anyone know of any potential problems running a 2000 database with
2003?

Also, what about installing all other Office products as 2003 versions but
leaving Access as 2002 running a 2000 database?

Why you ask! A client has a 2000 database. Currently using 2000 runtime for
most employees to work with database. A couple use 2003 to use database, no
problems. They have a mix of versions of other products such as Word,
Excel - 97, 2000 and 2002.

They are considering upgrading everything except Access to 2003, leaving the
Access 2000 runtime and Access 2002 retail in place - because they have
acquired Office 2003 SB (no Access) cheaply. However, they will upgrade the
retail Access to 2003 if they have to - another company looks after this for
them!!!!

Aaaaaaaaaaaaargh

Jeff
Nov 13 '05 #1
2 2303
You cannot create an Access MDE "compiled" database with Access 2003 that
will run with either the retail or runtime of Access 2000. That is the only
limitation I'd particularly note. In fact, the default file format (unless
you change it) generated by Access 2003 is the Access 2000 file format, but
for MDB or ADP only, not MDE nor ADE.

There may be other, less obvious, or more subtle problems... some people had
obviously had enough difficulties converting Access 97 databases to later
versions that Microsoft released some conversion assistance software for
Access 97 to Access 2003. I'd never had any particular problems with such
conversions, unless there were compile errors in the original (which is easy
to avoid, compile and fix the errors before converting).

Larry Linson
Microsoft Access MVP

"Jeff" <je************@asken.com.au> wrote in message
news:lA****************@news.optus.net.au...
Does anyone know of any potential problems running a 2000 database with
2003?

Also, what about installing all other Office products as 2003 versions but
leaving Access as 2002 running a 2000 database?

Why you ask! A client has a 2000 database. Currently using 2000 runtime for most employees to work with database. A couple use 2003 to use database, no problems. They have a mix of versions of other products such as Word,
Excel - 97, 2000 and 2002.

They are considering upgrading everything except Access to 2003, leaving the Access 2000 runtime and Access 2002 retail in place - because they have
acquired Office 2003 SB (no Access) cheaply. However, they will upgrade the retail Access to 2003 if they have to - another company looks after this for them!!!!

Aaaaaaaaaaaaargh

Jeff

Nov 13 '05 #2
Hi Larry

It is a 2000 MDE database that will be run in 2003. I didn't think there
would be any problems, but just need to check. I do run 2000 MDE with 2002,
but never tried it with 2003.

Jeff

"Larry Linson" <bo*****@localhost.not> wrote in message
news:lDSXc.226$Gr2.103@trnddc07...
You cannot create an Access MDE "compiled" database with Access 2003 that
will run with either the retail or runtime of Access 2000. That is the only limitation I'd particularly note. In fact, the default file format (unless
you change it) generated by Access 2003 is the Access 2000 file format, but for MDB or ADP only, not MDE nor ADE.

There may be other, less obvious, or more subtle problems... some people had obviously had enough difficulties converting Access 97 databases to later
versions that Microsoft released some conversion assistance software for
Access 97 to Access 2003. I'd never had any particular problems with such
conversions, unless there were compile errors in the original (which is easy to avoid, compile and fix the errors before converting).

Larry Linson
Microsoft Access MVP

"Jeff" <je************@asken.com.au> wrote in message
news:lA****************@news.optus.net.au...
Does anyone know of any potential problems running a 2000 database with
2003?

Also, what about installing all other Office products as 2003 versions but leaving Access as 2002 running a 2000 database?

Why you ask! A client has a 2000 database. Currently using 2000 runtime

for
most employees to work with database. A couple use 2003 to use database,

no
problems. They have a mix of versions of other products such as Word,
Excel - 97, 2000 and 2002.

They are considering upgrading everything except Access to 2003, leaving

the
Access 2000 runtime and Access 2002 retail in place - because they have
acquired Office 2003 SB (no Access) cheaply. However, they will upgrade

the
retail Access to 2003 if they have to - another company looks after this

for
them!!!!

Aaaaaaaaaaaaargh

Jeff


Nov 13 '05 #3

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...
3
by: Mike Gramelspacher | last post by:
Hello, I have an Access 2000 database that I copied to a new computer with Access 2003. Access 2003 says the file is in Access 2000 file format. I made some changes to the Access 2000 file...
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...
3
by: KEMDignam | last post by:
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...
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...
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...
13
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.