unrecognized database format

[Eric]

I just converted a word template that was created in Word 2003 to a Word
template in version 2007, so it has become a dotx file. The template contains
a macro that runs a VBA routine that reads data from an access accdb file
(2007).
The problem is that the routine stops at the followin line:

Set DB = OpenDatabase("q:\jas\fmc\RentalPayments\RentalPayments.accdb")
and it displays the message: runtime error 3343 - unrecognized database
format.

P.S. I have a correct reference set to Microsoft DAO 3.6 object library.

I really have no clue why the routine no longer fucntions.
Any help is most appreciated!!!

 

[Alex Dybenko]

Hi,
instead of DAO 3.6 you need to set reference to Microsoft Office 2007 Access
DB engine objects

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com