Prev: Excel prompts for VBA password when opening
Next: how to get address of source of copy (range with marquee a.k.a. "marching ants")
From: JT on 1 Feb 2010 12:16
I use the following constant in a number of macros without any issues:

Const ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\Corp\Public\Groups\Accounting\Trans.mdb; Persist Security Info=False"

I have sent a new macro to a user at one of our cost centers and they are
getting the following message:

"Y:\Public\Groups\Accounting\Brood\Trans.mdb; Persist Security Info=False"
is not a valid path. Make sure that the path name is spelled correctly and
that you are connected to the server on which the file resides."

When I looked at the drives his machine was mapped to, the
\Corp\Public\Groups\Accounting\ drive wasn't there. I then mapped this drive
to his machine and had him re-boot and still no luck.

I'm not sure where this path ("Y:\Public\Groups\Accounting\Brood\Trans.mdb)
is coming from. It is not in the code in the macro. I do not believe it is
any other macro that he may be using. All of the macros that I am aware of
use the database at \Corp\Public\Groups\Accounting\

Can it be hidden somewhere and I'm not seeing it?

Any help would be greatly appreciated. Thanks for the help.....This one has
me ready to pull my hair out because I have used this contstant in over 20
macros and have never encountered this issue before.


--
JT
From: goshute on 1 Feb 2010 15:39
Quick suggestions:
Look for any connections under the Data tab.
Also try searching EVERYTHING in the entire VBA Editor for the
string. Make sure their personal Workbook, which is a hidden
workbook, and all other hidden objects are included in the search as
well.
If there are any protected Add-In's that you can not search, turn them
off, one at a time, to see if they may be causing the issue.

Goshute
 | 
Pages: 1
Prev: Excel prompts for VBA password when opening
Next: how to get address of source of copy (range with marquee a.k.a. "marching ants")