[AccessD] Upgrade to Office 2003 - Access2k3

I have been running with Jet SP 8.0 for over a year so I have forgotten
any problems that might have occured but it doesn't affect my version of 97
2003 or 2007
There is a registry key, you can switch if sudden problems occur with 
sandbox
mode but some form of sandbox has been around since JetSP4
You should perhaps upgrade to Jet SP8 before installing Office 2003
It shouldn't affect you unless you are doing weird things in SQL
like SELECT Shell("c:\windows\System32\calc.exe") FROM Customers;
Sandbox protection applies not just to SQL but also to Form Event properties

Here is a long article explaining it from Gerry Robinson

 How To Avoid An Access 2003 Sandbox Storm
http://www.vb123.com/toolshed/04_docs/sandbox.htm


O'Connor, Patricia (OTDA) wrote:

>Marty - Thanks for the quick response. 
>
>I have not upgraded to SP2 yet. I am currently running a monthly system
>that has an A2k mdb, an excel workbook with 6 pivot table with graphs
>created from Excel queries (dqy). The dqy is what populates the tables
>which sets the graphs.  So I figured to run that first before upgrading
>just in case.  
>
>What about the SANDBOX unsafe expressions warning I get when opening my
>2k mdb.  It says to upgrade my jet Microsoft Jet 4.0 Service Pack 8.  If
>I update to this will my old systems no longer work?  I already have a
>4.08 version of Jet but it still comes up everytime.
>
>Thanks
>**************************************************
>* Patricia O'Connor
>* Associate Computer Programmer Analyst
>* OTDA - BDMA
>* (W) mailto:Patricia.O'Connor at otda.state.ny.us
>* (w) mailto:aa1160 at nysemail.state.ny.us
>**************************************************
> 
>
>  
>
>-----Original Message-----
>
>  
>
>>From: accessd-bounces at databaseadvisors.com 
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
>>MartyConnelly
>>Sent: Wednesday, August 02, 2006 04:54 PM
>>To: Access Developers discussion and problem solving
>>Subject: Re: [AccessD] Upgrade to Office 2003 - Access2k3
>>
>>well the two major ones I can think of
>>1.
>>http://support.microsoft.com/kb/904953/en-us
>>
>>This functionality has now been disabled "permanently" with 
>>Office 2003 SP2.
>>"Because of legal issues, Microsoft has disabled the 
>>functionality in Access
>>2003 and in Access 2002 that let users change the data in 
>>linked tables that point to a range in an Excel workbook."
>>2.
>> How you handle Office and Access Macro Security, there are 
>>various options in archives.
>>Not really a problem for a single user as can be disabled from menus.
>>
>>There are palso roblems with Outlook Forms and a lot of minor 
>>problems if you do an adminstrative install to a whole series 
>>of machines.
>>
>>If you run both Access 97 and 2003 from a non admin user you 
>>have to change an .srg file.
>>
>>    
>>

-- 
Marty Connelly
Victoria, B.C.
Canada