Inconsistent error when using ADODB in VBA with parameters for RecordSet Open

Question

This line of code:

rs.Open SQLStr, conn, adOpenStatic

is proving somewhat volatile - sometimes it runs with no problem, and sometimes it throws the error:

Variable not defined.

It appears to be the adOpenStatic causing problems. I'm trying to avoid referencing the ADODB library as it would then require all of my users to reference this library. If it didn't work full stop then fine but my frustration stems from the fact that sometimes it works and sometimes it doesn't.

Just wondered if anyone had come across this before and had a solution?

Why would you late bind this? "trying to avoid referencing the ADODB library as it would then require all of my users to reference this library" doesn't make any sense - if they don't have the library installed, CreateObject is going to throw anyway. — Comintern
– Comintern, Commented Jan 10, 2017 at 15:15

Kazimierz Jawor · Accepted Answer · 2017-01-10 15:08:06Z

1

When working with external libriary in late-binding mode you can not work with constants like adOpenStatic. Use 3 istead (just three) wich is numeric representation of adOpenStatic.

Other parameters and theirs numeric repesentations you can find here

answered Jan 10, 2017 at 15:08

Kazimierz Jawor

19.1k7 gold badges38 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inconsistent error when using ADODB in VBA with parameters for RecordSet Open

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related