Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
 Posted - 2005-06-02 : 20:53:59
|
| Dear gurusI am using Access 2003, I have installed Jet4.0 SP 8 and have read the following articles:Functions and properties that are blocked in sandbox modeHow to configure Jet 4.0 to prevent unsafe functions from running in Access 2003The second article states that setting the registry key to "2" means "Sandbox mode is used for non-Access applications, but not for Access Applications. This is the default value."However, I still get all the warnings in Access. Any clues?Secondly, the article states lists certain functions which generate an error "when called from a Jet query or an Access property" - does that mean called from VBA code in an control event?Is there any alternative method for doing things like "shell" and "kill" in a safe way (and without getting the prompt), or do I really just have to turn macro security off?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-03 : 07:59:35
|
| I have Always just turned off the macro security. But then I only give my users a shareware version of access and impose security at the SQL level using only SPs for interface (Thanks to Tara).JimUsers <> Logic |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-06-05 : 19:32:35
|
| Thanks Jim, but what do you mean by shareware version of access??--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-06 : 16:16:27
|
| Sorry I took so long to get back to you Rob. I mean the runtime version of Access. This comes as part of the Office XP developers version in the packaging wizard (I love this animal).Or you can download it [url]http://www.sharewaresoft.com/MS-Access-Runtime-Installer-download-13857.htm[/url]JimUsers <> Logic |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-06-06 : 19:27:30
|
| Thanks JimI thought you meant that, but then, hey, you never know.Cheers and Thanks--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Sandbox mode