Is dbPath using a mapped drive letter? Maybe their machine has not mapped
that drive. Have you tried using the UNC (\\server\dir\dbname.mdb) as a
test?
--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility
"jdg" wrote in message
...
Thank you for your reply, Apologies for leaving out the actual problem.
Unfortunately the person whose pc is giving the error has been out of
office
for the last few days so i have been unable to get the exact error
message. I
will be able to send the error message through on Monday.
The problem is that the code cannot connect to the database (which is
saved
on a network drive), its as if the it cant find the database, however i
checked that the file location (dbPath in code below) for the database was
correct. And it connects with no problem on all the other computers.
I will be able to provide more details on Monday though.
Thanks again.
"Tim Zych" wrote:
What's the problem?
--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility
"jdg" wrote in message
...
Hello
I created an excel addin which I am distributing to members of my
organisation. I have managed to install it successfully onto a number
of
computers however I am having problems with one computer.
The line that brings an error is as follows
dbConnectStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath
&
";"
Where dbConnectStr is a string variable used to set up the active
connection
to an access database for example
rs.Open strConnectionString, dbConnectStr, adOpenStatic,
adLockPessimistic
and dbPath is the file location of that database.
The computer which is giving problems has both excel 2007 and excel
2003
installed on it which I believe may be the cause of the problem, as all
the
other computers only have one or the other installed and the
application
works. However this is more of a guess and even if I were right I don't
know
how to fix the problem.
Any thoughts or advice would be appreciated.
Regards,