VBA - Word automation (mailmerge) - convert access 2007

[Yann]

Hi,

I have an Access 2003 application which uses Word mailmerge automation. I
works just fine. When I convert the access database to Access 2007, the Word
automation quits working, looking for a non existing database and the odbc
login driver fails.

Any ideas?

Yann

 

[Michael J. Strickland]

Hi,

I have an Access 2003 application which uses Word mailmerge
automation. I
works just fine. When I convert the access database to Access 2007,
the Word
automation quits working, looking for a non existing database and the
odbc
login driver fails.

Any ideas?

Yann

Are you using a database with a .accdb extension (Access 2007)?

Access 2007 uses *.accdb extensions unless you specify one of the
earlier formats when you save it.


--

 

[Yann]

Thanks,

Yes the converted database has indeed an accdb extension. Is this relevant?

Yann

 

[Michael J. Strickland]

Is your record source in your Word file using the correct name for your
database, with the accdb extension or the old .mdb extension?

Thanks,

Yes the converted database has indeed an accdb extension. Is this
relevant?

Yann

--