OpenCurrentDatabase using UNC for pathname

#1

I'm using the following code in Access 2002 to open a report in an external
db.

Dim objAccess As Access.Application
Set objAccess = New Access.Application
With objAccess
.OpenCurrentDatabase "\\server\dpcman\cheques.mdb"
.DoCmd.OpenReport strReport, acViewPreview, , , , gblPropNum
End With

An error 7866 (Can't open the database because it is missing or opened
exclusively by another user...") is generated at the line
".OpenCurrentDatabase.."
If I substitute that line for:
.OpenCurrentDatabase "c:\dpc manager 10\cheques.mdb" (which on my
development PC is the same path)
it works fine.

The Help screen for 'OpenCurrentDatabase' indicates that UNC can be used.
Is there any reason I can't use UNC in this context?
If so, is there a way to resolve the UNC path to generate the mapped path?

--
Bob Darlington
Brisbane

#2

Bob Darlington wrote:

Quote:

I'm using the following code in Access 2002 to open a report in an external
db.

Dim objAccess As Access.Application
Set objAccess = New Access.Application
With objAccess
.OpenCurrentDatabase "\\server\dpcman\cheques.mdb"
.DoCmd.OpenReport strReport, acViewPreview, , , , gblPropNum
End With

An error 7866 (Can't open the database because it is missing or opened
exclusively by another user...") is generated at the line
".OpenCurrentDatabase.."
If I substitute that line for:
.OpenCurrentDatabase "c:\dpc manager 10\cheques.mdb" (which on my
development PC is the same path)
it works fine.

The Help screen for 'OpenCurrentDatabase' indicates that UNC can be used.
Is there any reason I can't use UNC in this context?
If so, is there a way to resolve the UNC path to generate the mapped path?

Maybe the UNC path is incorrect?

http://www.wiredbox.net/forum/Thread..._drive_le.aspx

#3

Bob Darlington wrote:

Quote:

I'm using the following code in Access 2002 to open a report in an
external db.

Dim objAccess As Access.Application
Set objAccess = New Access.Application
With objAccess
.OpenCurrentDatabase "\\server\dpcman\cheques.mdb"
.DoCmd.OpenReport strReport, acViewPreview, , , ,
gblPropNum End With

An error 7866 (Can't open the database because it is missing or opened
exclusively by another user...") is generated at the line
".OpenCurrentDatabase.."
If I substitute that line for:
.OpenCurrentDatabase "c:\dpc manager 10\cheques.mdb" (which on
my development PC is the same path)
it works fine.

The Help screen for 'OpenCurrentDatabase' indicates that UNC can be
used. Is there any reason I can't use UNC in this context?

Nope. The permissions on the share you are using might not be allowing
the ldb file to be created/modified ...

--
HTH,
Bob Barrows

#4

Thanks Salad. I had tested that with Dir() and all is OK.

--
Bob Darlington
Brisbane
"Salad" <salad (AT) oilandvinegar (DOT) com> wrote

Quote:

Bob Darlington wrote:
I'm using the following code in Access 2002 to open a report in an
external db.

Dim objAccess As Access.Application
Set objAccess = New Access.Application
With objAccess
.OpenCurrentDatabase "\\server\dpcman\cheques.mdb"
.DoCmd.OpenReport strReport, acViewPreview, , , , gblPropNum
End With

An error 7866 (Can't open the database because it is missing or opened
exclusively by another user...") is generated at the line
".OpenCurrentDatabase.."
If I substitute that line for:
.OpenCurrentDatabase "c:\dpc manager 10\cheques.mdb" (which on my
development PC is the same path)
it works fine.

The Help screen for 'OpenCurrentDatabase' indicates that UNC can be used.
Is there any reason I can't use UNC in this context?
If so, is there a way to resolve the UNC path to generate the mapped
path?

Maybe the UNC path is incorrect?
http://www.wiredbox.net/forum/Thread..._drive_le.aspx

#5

I think the problem is solved.
I was testing the code on my development PC which is also the 'server' so
that the UNC path (which tests OK) doesn't seem to like refering to a UNC
address which is on the same PC.
I tested the same thing on a network from another PC and all is well.
Thanks for your replies.

--
Bob Darlington
Brisbane
"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote

Quote:

I'm using the following code in Access 2002 to open a report in an
external db.

Dim objAccess As Access.Application
Set objAccess = New Access.Application
With objAccess
.OpenCurrentDatabase "\\server\dpcman\cheques.mdb"
.DoCmd.OpenReport strReport, acViewPreview, , , , gblPropNum
End With

An error 7866 (Can't open the database because it is missing or opened
exclusively by another user...") is generated at the line
".OpenCurrentDatabase.."
If I substitute that line for:
.OpenCurrentDatabase "c:\dpc manager 10\cheques.mdb" (which on my
development PC is the same path)
it works fine.

The Help screen for 'OpenCurrentDatabase' indicates that UNC can be used.
Is there any reason I can't use UNC in this context?
If so, is there a way to resolve the UNC path to generate the mapped path?

--
Bob Darlington
Brisbane

#6

Bob Darlington wrote:

Quote:

Thanks Salad. I had tested that with Dir() and all is OK.

The UNC path is correct or you can open the database with the UNC path?

If not, you could get the drive letter from the UNC path (at load up
time) and substitue that instead of the UNC path.

#7

"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote in
news:4cc61db8$0$25361$afc38c87 (AT) news (DOT) optusnet.com.au:

Quote:

I was testing the code on my development PC which is also the
'server' so that the UNC path (which tests OK) doesn't seem to
like refering to a UNC address which is on the same PC.

I have never seen that. I do note that sometimes Windows Explorer
will convert a UNC path to its local equivalent (which is quite
annoying), but that's Windows Explorer, and not really relevant to
how Access/Jet/ACE handles UNC paths.

There might be firewall settings that interfere with it, though.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#8

Thanks David.
I'll recheck the firewall settings.

--
Bob Darlington
Brisbane
"David-W-Fenton" <NoEmail (AT) SeeSignature (DOT) invalid> wrote

Quote:

"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote in
news:4cc61db8$0$25361$afc38c87 (AT) news (DOT) optusnet.com.au:

I was testing the code on my development PC which is also the
'server' so that the UNC path (which tests OK) doesn't seem to
like refering to a UNC address which is on the same PC.

I have never seen that. I do note that sometimes Windows Explorer
will convert a UNC path to its local equivalent (which is quite
annoying), but that's Windows Explorer, and not really relevant to
how Access/Jet/ACE handles UNC paths.

There might be firewall settings that interfere with it, though.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

OpenCurrentDatabase using UNC for pathname

comp.databases.ms-access comp.databases.ms-access

OpenCurrentDatabase using UNC for pathname - 10-25-2010 , 02:01 AM

Re: OpenCurrentDatabase using UNC for pathname - 10-25-2010 , 04:10 AM

Re: OpenCurrentDatabase using UNC for pathname - 10-25-2010 , 10:33 AM

Re: OpenCurrentDatabase using UNC for pathname - 10-25-2010 , 06:18 PM

Re: OpenCurrentDatabase using UNC for pathname - 10-25-2010 , 07:15 PM

Re: OpenCurrentDatabase using UNC for pathname - 10-25-2010 , 07:21 PM

Re: OpenCurrentDatabase using UNC for pathname - 10-26-2010 , 02:42 PM

Re: OpenCurrentDatabase using UNC for pathname - 11-02-2010 , 05:32 PM