Opening a Database across an network

[cage4000]

I receive an error if I try to open an Access 2002 Database over my office
network. It states:


“Microsoft Access cannot open this file.

The file is located outside your network 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 machine or an accessible network location.â€


Is there a way to bypass this so that we can access the database without
having to copy the database to our computer?

Thanks,

Cage

 

['69 Camaro]

Hi, Cage.

Does this problem database have linked tables that are linked using an IP
address (\\123.123.123.1\SharedDir) or a fully qualified domain name
(\\ComputerName.OurDomain.com\SharedDir), instead of the Unified Naming
Convention (UNC) (\\ComputerName\SharedDir), or a hard-coded mapped drive
(T:\SharedDir)?

Those pesky little periods in the path name confuse the Office XP security
system.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[cage4000]

Hi Gunny,

It is a hard-coded mapped drive (T:\SharedDir). The exact path is
(T:\InboundTraffic.mdb). it is not part of a doman, just the same network
workgroup.

Thanks,

Cage

 

['69 Camaro]

Hi, Cage.

It is a hard-coded mapped drive

Use Internet Explorer's Internet Options to include this drive in your local
intranet. If that doesn't help, add the drive to your "Trusted sites." Use
the UNC name, not the drive letter, i.e., \\Camaro\InboundTraffic.mdb, not
T:\InboundTraffic.mdb.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[cage4000]

Gunny,

That did it, thanks. but now whan i open the database it will only alow me
to open it in "Read-Only" statis. is there a way to get past this to so
other users can input date on to the database?

Thanks,

Cage

 

['69 Camaro]

Hi, Cage.

That did it, thanks. but now whan i open the database it will only alow
me
to open it in "Read-Only" statis.

Does everyone who has permissions to this directory have Full Control
permissions? If so, is the first person to open the database not
restricted, yet every subsequent user who opens the database is warned that
it's "read-only"? If so, what happens when you open the database by first
opening Access, then opening the file by navigating to it, instead of
double-clicking on the file name in Windows Explorer or using a Windows
shortcut?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[cage4000]

They do have full control and the first person to open the database can only
open it in read-only states.

It gives them an “Open-File security warningâ€. They can ether click “Openâ€
or “Cancelâ€. After they click “Open†that is when it prompts then with
read-only states.

If I create short cut on the desktop or by navigating to it via the network
and double clicking or even if I try to open it with opening MS Access first
and opening it throw the program it will still give me a Read-only massage.
It will not give me the massage if I open it from the computer that it is
located on.

Thanks,

Cage

 

[aaron.kempf]

Access doesn't run across a network reliably

lose the training wheels; learn SQL Server

 

['69 Camaro]

Hi, Cage.

Check the file's attributes to ensure someone hasn't accidentally changed it
to read-only, and if you're using Windows XP SP-2, that the file is not
blocked. If those aren't the problems, it's possible that a process has the
file open, such as an anti-virus product on one of the computers on the
peer-to-peer network. A Windows network administrator has the tools to
check this for you. Other than that, please see the following Knowledge
Base article for any more ideas:

http://support.microsoft.com/kb/814112/en-us

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.