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