var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: opendatasource error
I'm having a little bit weird issue so bare with me.
I have database A and database B and I also have computer C and computer D.
computer C has access 2003 SP3 computer D has access 2003 SP2.
I have database A working just fine on C and D and
database B working on D.
When I've created database B I've simply copied the following code.
maindoc = "documentname"
pname = "path"
Dim objWord As Object
Set objWord = GetObject("\\path\" & maindoc & "", "Word.Document")
objWord.Application.Visible = True
objWord.MailMerge.OpenDataSource Name:=pname, SQLStatement:="SELECT * FROM table "
the only difference between the code in database A and B is the name of the document I'm trying to merge.
I'm receiving a run time error on computer C because the Name argument instead of picking up pname has a value of "Microsoft Access".
If this is an SP issue then why on earth database A working fine?
What am i missing?
any help would be appriciated.
What happens when you replace pname by its value, like this?
Have a nice day!
, SQLStatement:="SELECT * FROM table "