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

Access 2007 compatability with Access 2003

P: n/a
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
Dec 16 '07 #1
Share this Question
Share on Google+
10 Replies


P: n/a
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
Dec 16 '07 #2

P: n/a
On 16 Dec, 20:58, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Sun, 16 Dec 2007 12:53:55 -0800 (PST), Bobby

<bob...@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- Hide quoted text -

- Show quoted text -
MDB
Dec 16 '07 #3

P: n/a
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
Dec 16 '07 #4

P: n/a
On Dec 16, 3:53 pm, Bobby <bob...@blueyonder.co.ukwrote:
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.

Dec 16 '07 #5

P: n/a
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

Dec 17 '07 #6

P: n/a
On Dec 16, 7:27 pm, "Klaus Oberdalhoff" <k...@gmx.dewrote:
no more adp-files (only old Access 2003 file-format supported)
Access 2007 creates and opens adps.
Dec 17 '07 #7

P: n/a
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 <no.spam.tom7...@cox.netwrote:
>On Sun, 16 Dec 2007 12:53:55 -0800 (PST), Bobby

<bob...@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- Hide quoted text -

- Show quoted text -

MDB
Dec 17 '07 #8

P: n/a
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

Dec 17 '07 #9

P: n/a
lyle <ly************@gmail.comwrote in
news:2d**********************************@w40g2000 hsb.googlegroups.co
m:
On Dec 16, 7:27 pm, "Klaus Oberdalhoff" <k...@gmx.dewrote:
>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/
Dec 17 '07 #10

P: n/a
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!
Dec 17 '07 #11

This discussion thread is closed

Replies have been disabled for this discussion.