Can't open database through network

[Paul Kraemer]

Hi,

I have an Access 2002 database located on a PC running Windows XP Pro. This
PC is on my peer-to-peer LAN, where I have every computer in the same
workgroup. I used to be able to open this database from every computer on
the LAN.

All of a sudden, I can't open it from one particular PC running Windows
2000. Access gives me a message saying "MS Access cannot open this file.
This file is located outside your intranet or on an untrusted site. MS
Access will not open this file due to potential security problems. To open
this file, copy it to your machine or to an accessible network location."

I don't think this is a network problem because I am able to open this same
database from the problem PC if I open it with a custom visual basic
application that I wrote myself. I just can't open it in Access. I do have
Norton Internet Security installed, but if this was the problem, it would
also prevent my custom application from working too, right? Anyway, even if
I disable Norton, I still get the same message from Access.

I am able to open the database in Access from all of the other PC's on my
LAN. The only thing unusual about the problem PC is that it has two network
cards. One NIC gets it on the workgroup LAN with the PC hosting the database
file, and the other NIC connects it to a DSL modem.

If anyone has any ideas, I'd really appreciate it.

Thanks,
Paul

 

['69 Camaro]

Hi, Paul.

I have an Access 2002 database located on a PC running Windows XP Pro. This
PC is on my peer-to-peer LAN, where I have every computer in the same
workgroup. I used to be able to open this database from every computer on
the LAN.

All of a sudden, I can't open it from one particular PC running Windows
2000.

Either this Windows 2000 computer has had it's Internet Zone settings
changed recently or the database application is attempting to connect to
another file on the network that has a period in the path, like an IP
address. This can be from a linked table or a connection string in a query,
VBA code, macro, or a Property setting. Check to ensure that the computer
where this database resides is included inside the Windows 2000 computer's
Internet Zone. If it is, then check to ensure that all connections that
this database application makes have no period in the path's string.

I don't think this is a network problem because I am able to open this same
database from the problem PC if I open it with a custom visual basic
application that I wrote myself. I just can't open it in Access.

Access 2002's security model prevents you from opening it. Access 2002's
security model will refuse to open a database with a linked table if it
encounters periods in the path's string like either of the following:

\\100.100.100.100\SharedDir$\Data\MyDB.MDB

or

\\SharedServer\SharedDir$\Data.2004\MyDB.MDB

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)