By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,462 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

Access References Using UNC

P: n/a
Jay
Using a custom mda file that holds the code for the login sequence for
multiple Access 2000 databases. The problem occurs when the reference
path is changed to a UNC path. This happens when maintenance is
performed on the databases, the path changes from a drive letter to
the UNC path. Users to not have access to this path. Is there a way
to set the location through code for the path to the mda. I would
like to use this in case our developers forget to change the path back
to the drive letter. I want to trap the error and reset it to the
drive letter.

Basically, is there a way to get to the location of references without
going through the wizard in Visual Basic?

Thanks in advance.

Jay
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
There is a References object that may help

Sub test()
Dim ref As Reference
For Each ref In Application.References
MsgBox ref.Name
Next ref
End Sub

www.trigeminal.com has an article about "disambiguating" references to
be certain the system doesn't hang if one of the references is broken

On 7 Jul 2004 15:25:30 -0700, sp**********@colteng.com (Jay) wrote:
Using a custom mda file that holds the code for the login sequence for
multiple Access 2000 databases. The problem occurs when the reference
path is changed to a UNC path. This happens when maintenance is
performed on the databases, the path changes from a drive letter to
the UNC path. Users to not have access to this path. Is there a way
to set the location through code for the path to the mda. I would
like to use this in case our developers forget to change the path back
to the drive letter. I want to trap the error and reset it to the
drive letter.

Basically, is there a way to get to the location of references without
going through the wizard in Visual Basic?

Thanks in advance.

Jay

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Nov 13 '05 #2

P: n/a
Jay
This was helpful in viewing the references at runtime however the
values are in a read only state and I cannot change the fullpath
value.
Nov 13 '05 #3

P: n/a
You must remove the broken reference from the References collection,
then add a new one with the correct path.

References.Remove ref
References.AddFromFile fullpathname

On 8 Jul 2004 08:43:29 -0700, sp**********@colteng.com (Jay) wrote:
This was helpful in viewing the references at runtime however the
values are in a read only state and I cannot change the fullpath
value.

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.