System Error in ADODB connection code

**Jonsocks** · 11-07-2011, 11:21 AM

Hi all,

I'm currently trying to add some functionality into a form I have developed where we can append the results to an existing table in Access 2007. I am testing some code at the moment but getting an error that I can't seem to get round. The Error appears in a 'Microsoft Visual Basic' window and the message states: System Error &H80004005 (-2147467259). The error appears when I attempt to run the following code:

Please Login or Register  to view this content.

This is something I have stolen from the internet, I am very new to VBA so basic editing of existing code is about my limit. I have checked Microsoft ActiveX Data Objects 2.8 Library in Tools>References.

I've searched for a similar problem on the forum but couldn't see one, apologies if I've missed something glaringly obvious.

Many thanks in advance

Jon

**Jonsocks** · 11-08-2011, 12:28 PM

Hi all,

Solved it, not sure exactly what's done it, however, having re-edited the code a few times, changing the access extension to .mdb and also checking:

Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.0 Library

in Tools>References, this seems to have done the job. Now all I need to do is figure out how to add a reference to a database password in there, but that's a potential future issue for another time.

Thanks to everyone who had a look to see if they could help.

Jon