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

office 2007 / Access 2000

P: n/a
Neighbour has got a new `puter which came with Office 2007 (without Access )

He needs Access to run an app for his business.

He still has a copy of Office 2000 Pro.

Are there any issues with installing Access 2000 alongside Office 2007. ?

The app calls Outlook to send emails.

Will there be any problems when Access runs this - ? -

Dim stAppName As String

stAppName = "C:\Program Files\Microsoft Office\Office\outlook.exe"
Call Shell(stAppName, 1)

TIA
David B
Feb 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can use Access 2000 from Office 2000 Pro, even if you are using Office
2007. Just do a custom install of Office 2000, so you can elect to install
the Access component only.

If you have hard-coded path names into the app, that will fail, so the code
will need to be re-written. Interactions between the different versions may
fail, but you might be able to overcome the specific example you gave by
using SendMail to fire off an email.

Other components could fail as well, e.g. MS Graph, the Calendar control,
etc. Again there are workarounds for most of these, e.g. this simple little
popup calendar that is just an Access form so works in any version:
http://allenbrowne.com/ser-51.html

There are a few other compatibility issues listed here:
http://allenbrowne.com/Access2007.html#Compatibility

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David B" <da***@somewhere.fsnet.co.ukwrote in message
news:Qt******************************@bt.com...
Neighbour has got a new `puter which came with Office 2007 (without
Access )

He needs Access to run an app for his business.

He still has a copy of Office 2000 Pro.

Are there any issues with installing Access 2000 alongside Office 2007. ?

The app calls Outlook to send emails.

Will there be any problems when Access runs this - ? -

Dim stAppName As String

stAppName = "C:\Program Files\Microsoft Office\Office\outlook.exe"
Call Shell(stAppName, 1)

TIA
David B
Feb 28 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.