Open DataSource Works On Windows XP but not on Windows 2000

[Sandra Miller]

I am using VB.Net to automate Word 2003 mailmerge; the datasource is a
Microsoft Access database that has a database password. The code works fine
on my development computer which has Windows XP Professional (SP2 is not
installed) but it does not work on my deployment computer which has Windows
2000, SP4 installed. Both computers have Word 2003 installed. I thought it
might be a password problem but I removed the password and am still getting
the same error: "Word was unable to open the datasource."

Any help that you can provide would be greatly appreciated.

Thanks,
Sandy

 

[Peter Jamieson]

Do you have exactly the same version of Word on both machines? (as in Word
Help|About)

Can you post the details (i.e. the code, and the details of what each
parameter actually contains when the statement is executed) of your
OpenDataSource statement here please?

Is the database in the same folder in each case? Is it on the local machine,
or on a network path? Could there be a security/permissions issue?

Peter Jamieson

 

[Peter Jamieson]

The only thing(s) that make sense to me are that either
a. you have a DSN matching "DSN=" &
IO.Path.GetFileNameWithoutExtension(mclsAsset.IMDb) (in essence) on your
WinXP box but not on your Win2K box. Typically when you install Office it
creates a number of standard ODBC DSN's, but maybe someone created one with
the same name as the Access database you are using or
b. the DSN constructed using "DSN=" &
IO.Path.GetFileNameWithoutExtension(mclsAsset.IMDb) does not exist. but for
some reason the WinXP box behaves differently (could have a different
version of MDAC, ODBC or Jet?). However, I would be surprised if that was
the case.

Peter Jamieson

 

[Sandra Miller]

Peter:

I've finally given up trying to figure out the difference. I check my
Windows XP machine - no DSN. However, as a test, I went ahead and created a
system DSN on the Windows 2000 machine. The original code still didn't work.
Go figure. Although I hate these kinds of mysteries, at least I have a
workable solution. And it's back to other problems.

Thanks for all your help and suggestions.

Sandy