copy mdb file from drive A to drive C

[lieder]

I can open the mdb file in A drive, however after I copy it to drive C, I can find the mdb file in drive C, but I can not open it, the error message is:

this file is located outsite your intranet or on an untrusted site.

Could you tell me why and how to solve this problem?

Thank you very much.

Lieder

 

[FoxProProgrammer]

You might try creating a new database on your C drive. Then import all the objects from the database on the A drive to the new database on the C drive.

Best of luck. If you try this I hope it works.

dz

 

[FoxProProgrammer]

I read your message again, and the problem could be that the developer created code in the startup that checks the drive the database was opened from. If it isn't the A drive, they shut you down. If that's the case, you will have to open the database on the A drive, find the startup code, and modify it. I don't know if there is indeed code in the start up doing this, but is sure sounds like a possibility, and the error that you described doesn't sound like a standard Acccess error. It sounds more like a user defined message.

Best of luck.

dz

 

[lieder]

I followed your instruction and created a new database in drive C, when I import the database from driver A to driver C, I got the same problem. And I know the original author will not add any code for not copying.
the database I managed is small, so I can input it by manual again, however I still wonder why I can not copy it from driver A to driver C.

Anyway, thank you very much and have a good weekend.

 

[FoxProProgrammer]

You can email the database to me if you want. There's no guarantee that I will be able to fix it, but I'll at least take a look at it. If you post your email address, I'll reply to you.

Best regards,

dz

 

[lieder]

My email is liederman_lee@yahoo.com, please let me know your email address so that I can email my small database to you. In fact, after I send you email in the future, when you save the attachment in your computer and try to open it, you will get the problem I have now.

I have other two questions, I would like to let you know, if you know the answers, please send me email.

1. I use Frontpage to connect a database, then use insert database results wizard to create a table, I want to add hyperlink to items in the table so that when one of them is clicked, another query result table will appear, how can I do that? I have read the help menu, and I do not think there is any useful information there.

2. If I have two internet databases under the same directory, then both of them will share the same global.asa file, I was told that if I put the internet databases in different directories, then each of them will have its own golbal.asa file. I followed this instruction, I found that the system will put my database in fpdb folder automaticlly, so that they still share the same global.asa file. If I want to have separate global.asa file, how can I implement this?

Thank you very much for your time and help.

Lieder

 

[FoxProProgrammer]

Lieder,

An email is on the way to you. I don't have any experience with your other two issues. So they don't get lost in this thread, you might start a new thread to see if someone can help you with them. Regarding your issue with not being able to open the mdb on drive C, I assumed that I could open it from my A drive. If not, I don't think that I will be able to do anything, but I'll try.

Best,

dz

 

[Guest_imported]

Your error message sounds like internet explorer security settings. I found same message in Microsoft Knowledge Base article number Q303650 Intranet Site Identified as Internet When You Use FQDN or IP. Go to

http://support.microsoft.com

and search for above Q article. Copy of text below. Hope this points you in the right direction as to what might be going on.



The information in this article applies to:

- Microsoft Windows 2000 Advanced Server
- Microsoft Windows 2000 Datacenter Server
- Microsoft Windows 2000 Professional
- Microsoft Windows 2000 Server
- Microsoft Windows NT Server version 4.0
- Microsoft Windows NT Workstation version 4.0
- Microsoft Internet Explorer versions 5.01, 5.01 Service Pack 1, 5.01 Service Pack 2, 5.5, 5.5 Service Pack 1 for Windows 2000
- Microsoft Internet Explorer versions 4.0, 4.01, 4.01 Service Pack 1, 4.01 Service Pack 2, 5, 5.01, 5.01 Service Pack 1, 5.01 Service Pack 2, 5.5, 5.5 Service Pack 1 for Windows NT 4.0
- Microsoft Internet Explorer versions 5.5, 5.5 Service Pack 1 for Windows Millennium Edition
- Microsoft Internet Explorer versions 5, 5.01, 5.01 Service Pack 1, 5.01 Service Pack 2, 5.5, 5.5 Service Pack 1 for Windows 98 Second Edition
- Microsoft Internet Explorer versions 4.01 Service Pack 1, 4.01 Service Pack 2, 5, 5.01, 5.01 Service Pack 1, 5.01 Service Pack 2, 5.5, 5.5 Service Pack 1 for Windows 98
- Microsoft Access 2002
- Microsoft Windows Millennium Edition
- Microsoft Windows 98 Second Edition
- Microsoft Windows 98
- Microsoft Internet Explorer version 6 for Windows 98
- Microsoft Internet Explorer version 6 for Windows 98 Second Edition
- Microsoft Internet Explorer version 6 for Windows Millennium Edition
- Microsoft Internet Explorer version 6 for Windows NT 4.0
- Microsoft Internet Explorer version 6 for Windows 2000
- Microsoft Internet Explorer version 6 for Windows XP
- Microsoft Internet Explorer version 6 for Windows XP 64-Bit Edition
-------------------------------------------------------------------------------

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

Q256986 Description of the Microsoft Windows Registry

SYMPTOMS
========

When you access a local area network (LAN) or intranet share, or intranet Web
site by using an Internet Protocol (IP) address or fully qualified domain name
(FQDN), the share or Web site is identified as being in the Internet zone
instead of the Local intranet zone. For example, this behavior can occur when
you access shares or Web sites with Internet Explorer, Windows Explorer, a
command prompt (for example, by using the net use command), or a Windows-based
program when you use an address in any of the following formats:

- \\<Computer>.<childdomain>.<domain>.com\<Share>

-

http://<computer>.<childdomain>.<domain>.com

- \\157.54.100.101\share

- file://157.54.100.101/share

-

http://157.54.100.101

This behavior can occur regardless of whether any or all of the following
settings are in place:

- In Internet Explorer, you have added the FQDN (or <*.domain.com>) or IP
address (or address range) to the &quot;Do not use proxy server for addresses
beginning with&quot; box that is under the Exceptions section in the Proxy
Settings dialog box (that is accessed from the Connections tab on the
Internet Options dialog box).

- You have clicked to select the &quot;Bypass proxy server for local addresses&quot;
check box that is on the Local Area Network (LAN) Settings dialog box, which
is accessed from the Connections tab on the Internet Options dialog box.

- You have clicked to select the &quot;Include all sites that bypass the proxy
server&quot; and the &quot;Include all network paths (UNCs)&quot; check boxes on the Local
intranet dialog box that is accessed from the Security tab on the Internet
Options dialog box.

This behavior can cause Internet Explorer to prompt you for a user name, domain
name, and password when you access the intranet Web sites that require
authentication, or you may be prevented from opening files on an intranet Web
site or universal naming convention (UNC) share in programs that use the
Microsoft Internet Explorer Security Manager to determine whether a file is
located in a trusted security zone. For example, you can receive the following
error message when you attempt to open a Microsoft Access database (.mdb) file
on a local intranet share or Web site with Microsoft Access 2002:

Microsoft Access cannot open this file.
This file is located outside your intranet or on an untrusted site. Microsoft
Access will not open the file due to potential security problems.
To open the file, copy it to your computer or an accessible network location.

CAUSE
=====

This behavior can occur because an FQDN or IP address contains periods, which
causes Internet Explorer to identify the Web site or share as being in the
Internet zone.

WORKAROUND
==========

WARNING: If you use Registry Editor incorrectly, you may cause serious problems
that may require you to reinstall your operating system. Microsoft cannot
guarantee that you can solve problems that result from using Registry Editor
incorrectly. Use Registry Editor at your own risk.

To work around this behavior, each user must add <*.domain.com> or the
appropriate IP address range to the Local Intranet Sites dialog box:

1. In Internet Explorer, click Tools, and then click Internet Options.

2. On the Security tab, click Local intranet and then click Sites.

3. Click Advanced, and then type: &quot;<*.domain.com>&quot; (without the quotation
marks) or an IP address range (for example, 157.54.100-200.*) in the &quot;Add
this Web site to the zone&quot; box (where <domain.com> is your company and
top-level domain names).

4. Click Add, click OK, click OK, and then click OK to close the Internet
Options dialog box.

5. Reboot the computer.

Administrators can deploy this setting by making the following changes to the
registry:

1. For each domain that should be included in the Local intranet zone, add a
<domain.com> key to the following registry key under either
HKEY_CURRENT_USER (for a currently logged-on user only) or HKEY_LOCAL_MACHINE
(for all users on the local computer):

Software\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\Domains

2. Add a DWORD value named * (the asterisk character) to the <domain.com>
key and set it to 1.

3. For each IP address range that must be included in the Local intranet zone,
add a Range<x> key (where x is 1, 2, 3, and so on) to the following
registry key under HKEY_CURRENT_USER (for a currently logged-on user only) or
HKEY_LOCAL_MACHINE (for all users on the local computer):

Software\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\Ranges

4. Add a DWORD value named * (the asterisk character) to the Range<x> key
and set it to 1.

5. Add a String value named :Range (the colon character followed by the word
&quot;Range&quot to the Range<x> key, and then set it to the IP address range
(for example, 157.54.100-200.*).

IMPORTANT: This workaround does not work for a file:// address that uses an IP
address. For example, Internet Explorer identifies \\157.54.100.101\share, or
file://157.54.100.101/share, as being in the Internet zone, even if you add the
appropriate IP address range to the Local Intranet Sites list.

STATUS
======

This behavior is by design.

Additional query words: dfs

 

[Guest_imported]

Your error message sounds like internet explorer security settings. I found same message in Microsoft Knowledge Base article number Q303650 Intranet Site Identified as Internet When You Use FQDN or IP. Go to

http://support.microsoft.com

and search for above Q article. Copy of text below. Hope this points you in the right direction as to what might be going on.



The information in this article applies to:

- Microsoft Windows 2000 Advanced Server
- Microsoft Windows 2000 Datacenter Server
- Microsoft Windows 2000 Professional
- Microsoft Windows 2000 Server
- Microsoft Windows NT Server version 4.0
- Microsoft Windows NT Workstation version 4.0
- Microsoft Internet Explorer versions 5.01, 5.01 Service Pack 1, 5.01 Service Pack 2, 5.5, 5.5 Service Pack 1 for Windows 2000
- Microsoft Internet Explorer versions 4.0, 4.01, 4.01 Service Pack 1, 4.01 Service Pack 2, 5, 5.01, 5.01 Service Pack 1, 5.01 Service Pack 2, 5.5, 5.5 Service Pack 1 for Windows NT 4.0
- Microsoft Internet Explorer versions 5.5, 5.5 Service Pack 1 for Windows Millennium Edition
- Microsoft Internet Explorer versions 5, 5.01, 5.01 Service Pack 1, 5.01 Service Pack 2, 5.5, 5.5 Service Pack 1 for Windows 98 Second Edition
- Microsoft Internet Explorer versions 4.01 Service Pack 1, 4.01 Service Pack 2, 5, 5.01, 5.01 Service Pack 1, 5.01 Service Pack 2, 5.5, 5.5 Service Pack 1 for Windows 98
- Microsoft Access 2002
- Microsoft Windows Millennium Edition
- Microsoft Windows 98 Second Edition
- Microsoft Windows 98
- Microsoft Internet Explorer version 6 for Windows 98
- Microsoft Internet Explorer version 6 for Windows 98 Second Edition
- Microsoft Internet Explorer version 6 for Windows Millennium Edition
- Microsoft Internet Explorer version 6 for Windows NT 4.0
- Microsoft Internet Explorer version 6 for Windows 2000
- Microsoft Internet Explorer version 6 for Windows XP
- Microsoft Internet Explorer version 6 for Windows XP 64-Bit Edition
-------------------------------------------------------------------------------

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

Q256986 Description of the Microsoft Windows Registry

SYMPTOMS
========

When you access a local area network (LAN) or intranet share, or intranet Web
site by using an Internet Protocol (IP) address or fully qualified domain name
(FQDN), the share or Web site is identified as being in the Internet zone
instead of the Local intranet zone. For example, this behavior can occur when
you access shares or Web sites with Internet Explorer, Windows Explorer, a
command prompt (for example, by using the net use command), or a Windows-based
program when you use an address in any of the following formats:

- \\<Computer>.<childdomain>.<domain>.com\<Share>

-

http://<computer>.<childdomain>.<domain>.com

- \\157.54.100.101\share

- file://157.54.100.101/share

-

http://157.54.100.101

This behavior can occur regardless of whether any or all of the following
settings are in place:

- In Internet Explorer, you have added the FQDN (or <*.domain.com>) or IP
address (or address range) to the &quot;Do not use proxy server for addresses
beginning with&quot; box that is under the Exceptions section in the Proxy
Settings dialog box (that is accessed from the Connections tab on the
Internet Options dialog box).

- You have clicked to select the &quot;Bypass proxy server for local addresses&quot;
check box that is on the Local Area Network (LAN) Settings dialog box, which
is accessed from the Connections tab on the Internet Options dialog box.

- You have clicked to select the &quot;Include all sites that bypass the proxy
server&quot; and the &quot;Include all network paths (UNCs)&quot; check boxes on the Local
intranet dialog box that is accessed from the Security tab on the Internet
Options dialog box.

This behavior can cause Internet Explorer to prompt you for a user name, domain
name, and password when you access the intranet Web sites that require
authentication, or you may be prevented from opening files on an intranet Web
site or universal naming convention (UNC) share in programs that use the
Microsoft Internet Explorer Security Manager to determine whether a file is
located in a trusted security zone. For example, you can receive the following
error message when you attempt to open a Microsoft Access database (.mdb) file
on a local intranet share or Web site with Microsoft Access 2002:

Microsoft Access cannot open this file.
This file is located outside your intranet or on an untrusted site. Microsoft
Access will not open the file due to potential security problems.
To open the file, copy it to your computer or an accessible network location.

CAUSE
=====

This behavior can occur because an FQDN or IP address contains periods, which
causes Internet Explorer to identify the Web site or share as being in the
Internet zone.

WORKAROUND
==========

WARNING: If you use Registry Editor incorrectly, you may cause serious problems
that may require you to reinstall your operating system. Microsoft cannot
guarantee that you can solve problems that result from using Registry Editor
incorrectly. Use Registry Editor at your own risk.

To work around this behavior, each user must add <*.domain.com> or the
appropriate IP address range to the Local Intranet Sites dialog box:

1. In Internet Explorer, click Tools, and then click Internet Options.

2. On the Security tab, click Local intranet and then click Sites.

3. Click Advanced, and then type: &quot;<*.domain.com>&quot; (without the quotation
marks) or an IP address range (for example, 157.54.100-200.*) in the &quot;Add
this Web site to the zone&quot; box (where <domain.com> is your company and
top-level domain names).

4. Click Add, click OK, click OK, and then click OK to close the Internet
Options dialog box.

5. Reboot the computer.

Administrators can deploy this setting by making the following changes to the
registry:

1. For each domain that should be included in the Local intranet zone, add a
<domain.com> key to the following registry key under either
HKEY_CURRENT_USER (for a currently logged-on user only) or HKEY_LOCAL_MACHINE
(for all users on the local computer):

Software\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\Domains

2. Add a DWORD value named * (the asterisk character) to the <domain.com>
key and set it to 1.

3. For each IP address range that must be included in the Local intranet zone,
add a Range<x> key (where x is 1, 2, 3, and so on) to the following
registry key under HKEY_CURRENT_USER (for a currently logged-on user only) or
HKEY_LOCAL_MACHINE (for all users on the local computer):

Software\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\Ranges

4. Add a DWORD value named * (the asterisk character) to the Range<x> key
and set it to 1.

5. Add a String value named :Range (the colon character followed by the word
&quot;Range&quot to the Range<x> key, and then set it to the IP address range
(for example, 157.54.100-200.*).

IMPORTANT: This workaround does not work for a file:// address that uses an IP
address. For example, Internet Explorer identifies \\157.54.100.101\share, or
file://157.54.100.101/share, as being in the Internet zone, even if you add the
appropriate IP address range to the Local Intranet Sites list.

STATUS
======

This behavior is by design.

Additional query words: dfs