My work just changed over from Windows XP/Office 2007 to Windows 7/Office 2010 and I'm starting to see some problems with my databases.
I have a command button on a form to open a picture. The code behind the button looks like this...
Call Shell("C:\Program Files\Microsoft Office\OFFICE12\OIS.EXE " & Chr(34) & "T:\ Path to folder\01.JPG" & Chr(34), vbMaximizedFocus)
I changed OFFICE12 to OFFICE14, but can't find the file OIS.EXE to open Microsoft Office Picture Manager. The OFFICE14 folder doesn't have any .exe files at all. Are the EXE files hidden somehow, or do I need to find the path to something else in Office 2010?
Another problem I have heard about but haven't seen...when someone opens a database, they get a message saying they do not have exclusive use to the database, and cannot make any changes. They can click "OK" 7 or 8 times and get in, but it is an annoyance, and they are just trying to use the database anyway, not make any changes to the design. Any way I can fix this?
Thank you for your help!