Access 2007 compatability with Access 2003

[Bobby]

Hi,
The organisation I work for is on the verge of buying Microsoft Office
2007 Pro Plus OLP NL. We currently use Office Pro 2003. Our business
system is written in Access 2003 with a SQL Server back end.

I've heard that it's possible that the version of Office we are buying
may have compatability issues with Access 2003. I find this hard to
believe, but does anybody know anything about this?

Thanks

Colin

[Tom van Stiphout]

On Sun, 16 Dec 2007 12:53:55 -0800 (PST), Bobby
<bo****@blueyonder.co.ukwrote:

Are you using MDB or ADP?
-Tom.

>Hi,
The organisation I work for is on the verge of buying Microsoft Office
2007 Pro Plus OLP NL. We currently use Office Pro 2003. Our business
system is written in Access 2003 with a SQL Server back end.

I've heard that it's possible that the version of Office we are buying
may have compatability issues with Access 2003. I find this hard to
believe, but does anybody know anything about this?

Thanks

Colin

[Bobby]

On 16 Dec, 20:58, Tom van Stiphout <[e-mail]:

On Sun, 16 Dec 2007 12:53:55 -0800 (PST), Bobby

<[e-mail]:

Are you using MDB or ADP?
-Tom.

Hi,
The organisation I work for is on the verge of buying Microsoft Office
2007 Pro Plus OLP NL. We currently use Office Pro 2003. Our business
system is written in Access 2003 with a SQL Server back end.

I've heard that it's possible that the version of Office we are buying
may have compatability issues with Access 2003. I find this hard to
believe, but does anybody know anything about this?

Thanks

Colin- Hide quoted text -

- Show quoted text -

MDB

[Rick Brandt]

Bobby wrote:

Hi,
The organisation I work for is on the verge of buying Microsoft Office
2007 Pro Plus OLP NL. We currently use Office Pro 2003. Our business
system is written in Access 2003 with a SQL Server back end.

I've heard that it's possible that the version of Office we are buying
may have compatability issues with Access 2003. I find this hard to
believe, but does anybody know anything about this?

It isn't so much a "compatibility" issue so much as it is that Access 2007 (like
most new MS software) has a few "issues". You will have to deal with the fact
that the interface is radically different and you might have a few things you
need to tweak here and there. Your users are more likely to complain about the
interface changes than the few bugs that come up.

Service Pack 1 has just been announced so hopefully that clears up a few of the
issues I have encountered.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[lyle]

On Dec 16, 3:53 pm, Bobby <[e-mail]:

Hi,
The organisation I work for is on the verge of buying Microsoft Office
2007 Pro Plus OLP NL. We currently use Office Pro 2003. Our business
system is written in Access 2003 with a SQL Server back end.

I've heard that it's possible that the version of Office we are buying
may have compatability issues with Access 2003. I find this hard to
believe, but does anybody know anything about this?

Thanks

Colin

I find Access 2007 to be very slow except on recently assembled
powerful machines. A dual core processor and 2 gig or more of ram seem
to tame the beast.
I'd worry a lot more about speed than about compatability.
Recently I uninstalled Access 2007 and replaced it with Access 2002 on
my laptop.

Of course, others may have had a different experience.

When Access 2007 first appeared I found that compacting an accdb file
sometimes erased it. I mean that it disappeared. A couple of other
people reported similar problems.

I downloaded and installed SP1 today but of course can't comment on
any noticeable changes yet.

The download and installation were painless.

[Klaus Oberdalhoff]

Hi,

I've heard that it's possible that the version of Office we are buying
may have compatability issues with Access 2003. I find this hard to
believe, but does anybody know anything about this?

yes, true according to German usegroup.

Access 2007
totally new Interface
I think you've to change your menues to team up.

no more MDW files / no security on that point, but that should be not
relevant if using SQL Server as a backend

no more adp-files (only old Access 2003 file-format supported)
no more "Data Access pages"

Best bet: Set up a Virtual Maschine and test your application thoroughly in
beforehand.

mfg

Klaus

[lyle]

On Dec 16, 7:27 pm, "Klaus Oberdalhoff" <[e-mail]:

no more adp-files (only old Access 2003 file-format supported)

Access 2007 creates and opens adps.

[Tom van Stiphout]

On Sun, 16 Dec 2007 13:09:01 -0800 (PST), Bobby
<bo****@blueyonder.co.ukwrote:

Then you should have only minor incompatibility problems. Be sure to
install SP1 right away.

-Tom.

>On 16 Dec, 20:58, Tom van Stiphout <[e-mail]:

>On Sun, 16 Dec 2007 12:53:55 -0800 (PST), Bobby

<[e-mail]:

Are you using MDB or ADP?
-Tom.

>Hi,
The organisation I work for is on the verge of buying Microsoft Office
2007 Pro Plus OLP NL. We currently use Office Pro 2003. Our business
system is written in Access 2003 with a SQL Server back end.

>I've heard that it's possible that the version of Office we are buying
may have compatability issues with Access 2003. I find this hard to
believe, but does anybody know anything about this?

>Thanks

>Colin- Hide quoted text -

- Show quoted text -

MDB

[Linq Adams via AccessMonster.com]

Allen Browne, the "Wonder From Down Under," has an excellent white paper
called Access 2007: The Good, the Bad and the Buggy!

http://allenbrowne.com/Access2007.html#Good

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200712/1

[David W. Fenton]

lyle <ly************@gmail.comwrote in
news:2d**********************************@w40g2000 hsb.googlegroups.co
m:

On Dec 16, 7:27 pm, "Klaus Oberdalhoff" <[e-mail]:

>no more adp-files (only old Access 2003 file-format supported)

Access 2007 creates and opens adps.

And MDBs.

I wish people would stop to understand that just because MS doesn't
inplement a new file format for ADP and/or MDB in a version of
Access while introducing a 3rd format does not mean that the old
formats are obsolete. They aren't by any stretch of the imagination.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[anthony]

http://allenbrowne.com/Access2007.html#Good

That's an excellent link - thank you - and saves me asking the runtime
question I was going to ask. For my purposes, the case for upgrading
to 2007 is now very strong indeed. However, I know there's trouble
ahead as the first form I tried to open (perfectly working form in
2003) failed with an error. I hope I don't have to change too much
code because for most of it I've forgotten how I did it!