Access 2003 and compatibility access 2007

[Anne]

I have two databases working in two different companies. I tried to open one
of them in office 2007 and found that it is really very different, especially
the security and I was sure I would be a big problem converting it and making
sure everything works. Actually 2007 really messed up the database and
changed most of the libraries, which then caused major problems. It seems you
can't run these version side by side.

I am worried that one users computer will crash or I get a new user with a
new computer and office 2003 is no longer readily available and they will be
forced to buy office 2007.

Will everyone have to upgrade at that point. Should I be preparing the
conversion to office 2007 and should I go to Ebay and buy some versions 2003
to not have to worry about it?

 

[Douglas J. Steele]

There's no real problem running Access 2003 and Access 2007 on the same
machine (other than the fact that it takes a long time to switch from one to
the other). I'd be curious to know what issues you had.

You're right that Security has changed in Access 2007. If you use the Access
2007 file format (.ACCDB), there is no user-level security. It it there if
you use the Access 2003 file format (.MDB), but there's no user interface
for it.

As long as you have the media for Office 2003, you may be able to purchase
Office 2007, but install Office 2003. Check
http://download.microsoft.com/downl...64f-953c-4eacea2a38c1/VL_downgrade_rights.doc
for details.

 

[Anne]

I have a second laptop now and I am planning to reinstall office 2007 on it
and taking 2003 off. I will advise and let you know if I will have the same
problem again.
I will also try and see if my version of Office 2007 (I bought it when it
first came out and gave quickly up on it because of it being so slow with
both versions installed) can downgrade to office 2003. Interesting, I never
thought it would be possible.
Thank you

 

[Mark A. Sam]

I had a big problem running Office2002 and Office 2007 side by side. When I
installed a trial version of Office 2007, the Windows installer came up when
I went from 2007 to 2002. The 2007 configuration came up when I went from
2002 to 2007. My system became so unstable that I reinstalled WindowsXP.
Then I installed Office2002. When I installed 2007 then 2002 was rendered
inoperable so I uninstalled it. I installed Office 2002 on our main file
server and access it through Remote Desktop. Its a real nuisance. There
are also issues running an .mdb file using 2007. Some things just don't
work.