Cannot connect to Access database

[estronutz]

Hi all,

I've used the following VBA code to

Please Login or Register  to view this content.

However, a compile error occurred.

Compile error:
User-defined type not defined

How should I go about solving it ? Thanks in advance

[antoka05]

Did you remember to activate the reference?

Do so:
1) From excel, open VB editor (usually shortcut is 'Alt' and 'F11')
2) From the menu choose 'Tools', then 'References'
3) From the list choose 'Microsoft DAO x.x Object Library'

I think this may fix your problem.

Regards,
Antonio

[estronutz]

Thanks a mil !!!