Opening an MDB file on a 2003 Server cluster

[Rob H]

Hey there All,

We just upgraded our W2k member server that is only used for file storage to
a two W2k2 Ent Server Cluster. $$$

User has all access to MS Access 2002 MDB file on cluster and the directory.
When they try to open via File/Open or clicking directly on MDB file:
"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 machine or
an accessible network location." We have a single domain, other files like
..doc .xls can open fine in same directory. The network share is
\\our-domain-name.local\root\2005Projects and is mapped to a drive letter.

I am very new to MS Clustering.

Any Ideas? Copying the DB to the local, is not an option as the MS dialog
suggests.

Thanks!!!
Rob H

 

[DBS]

It's probably being caused by the dot (.) in "our-domain-name.local". Access
won't let you open anything with a dot in the filename or path.

See the following KB article:
You receive an error message when you try to open an Access 2002 database
from a Web Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;810582

Hope that helps!

David

 

[Rob H]

Thank you! Got it to work.

Your response directed me try the name \\datac\root in our drive mappings
(without the dot) rather than \\our-company.local\root. The person who setup
the cluster said to use the latter... Which was also causing file version
issues that I think are also now resolved.


Rob H