We have an Access 2002-2003 format .mde database in a shared folder on our network that is being shared by several users. All of the users have Access 2003 and only one of them can run the reports launched from the switchboard. One of them was able to run it last week but this week they can't. I don't know what has changed.
I've been doing some reading at various sites about the Jet sandbox but I'm having a difficult time figuring out what to do to make this work for all of the users. Can someone give me a step by step approach to troubleshooting?
Is my understanding even close?:
1)Make sure latest Jet service pack is installed on the workstation - search for Msjet40.dll and check version - install latest if necessary
2)Once Jet is current, either
a)set Macro Security to Low
b)or digitally sign the database(?)
Another idea I haven't tried yet is recreating this database in Access 2002 format. Would that avoid the sandbox problem?
Any direction on this would be greatly appreciated.
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only