?
Solved

Microsoft, Access, 2007 (Runtime), Stored on Novell Netware network

Posted on 2008-09-22
6
Medium Priority
?
64 Views
Last Modified: 2012-06-10
I would like to disable the security notice when opening an Access Runtime 2007 database which is located on a NetWare volume.  The "Trusted Locations" regedit works fine for Windows NTFS locations, but seems to do nothing for locations on a Novell Netware network.  (I have attempted using full path, as well as mapped drive path.)
0
Comment
Question by:CSSC
  • 3
  • 2
6 Comments
 
LVL 85
ID: 22541644
You might try setting Macro security to Low, if you can still do that on 2007. Other than that, I'm not sure how you'd achieve this. There is no simple setting that controls this.
0
 

Author Comment

by:CSSC
ID: 22561766
This is a Runtime environment.  No security setting is available.
0
 
LVL 85
ID: 22561927
You can expose the necessary menuitems to do this ... or do it via VBA, if need be.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:CSSC
ID: 22562149
Can you please give an example?
0
 
LVL 19

Expert Comment

by:billmercer
ID: 22599645
Just for giggles, give this a try:

In the Internet Properties control panel, go to security, click on Local Intranet, then click the Sites button.

Uncheck Automatically detect Intranet Network and check the other three boxes
(Include all local sites, Inculde all sites that bypass the proxy, and Include all network paths.)
0
 

Accepted Solution

by:
CSSC earned 0 total points
ID: 22613229
After more research, trial, and error, I have found something that works.  (I thought I had tried this before.)
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations]
"AllowNetworkLocations"=dword:00000001
 
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\XXXX]
"Path"="X:\\XDIR1X\\XDIR2X\\" 

Open in new window

0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question